3 - Qlik Sense Interview Questions | Sorting Year Month | Dual

In this video, I have shared another common Qlik Sense interview question, If you know the answer, comment below, If you dint know, I have shared the answer in the end.

This is part 3 of the long Qlik sense interview question series, so if you are learning something new make sure you subscribe. Also, check the previous video.

[dushyantlakhanpal]

Hi! What is the logic behind multiplying year by 100 and adding month to it?

[munendrarathore]

Hello Bhai...I have the. Same format. if I want to calculate sales for current month and previous month ..then what script I should write

[sathyadeenadayalan]

Simple trick is year(date)&month(date) asYearMonth . Achieving this will result Next you can simply call this column in front end table and go for sorting in Ascending or descending.

[philliparnesen]

This video isn't that helpful without understanding why you multiply the year value by 100. I don't understand this.