Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List months in calander date order


Hi,

This little thing is really starting to bug me.  I have a list box of months and I want them in calander date order, can anyone advise how to get this??

Many thanks,

Sara

10 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Try this in your sort tab expression.

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

Regards

ASHFAQ