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: 
Not applicable

How to sort the months according to the name ?

How to sort the months according to the name ?

2 Replies
mjayachandran
Creator II
Creator II

= match([XYZ Month],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'))

you can put the months in any order

ashfaq_haseeb
Champion III
Champion III

Hi,

use this expression under sort

Dual("Your Month Field",match("Your Month Field" ,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'))

Check this

I want to arrange date in order of ascending order

Regards

ASHFAQ