Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Month Sort Issue

Hi All,

I have month field like 01,02,03....12 and i converted it at front end as below

Pick(Match(Month,01,01,03,04,05,06,07,08,09,10,11,12), 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

And I tried to sort order like Jan...Dec however i could not make it. Could you please assist with this.

Thanks,

Nihhal.

1 Reply
sunny_talwar

Use this instead

Month(Date#(Month, 'MM'))