Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

custom sort expression

Hi,

I want to sort the months: Jan, Feb, Mar, Apr, May ....etc using a formula in the sort tab under expression. This is because as we use financial month numbers Jan isnt loaded in order first as Jul is the first financial month.

How do I do this?

Thanks

David

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3731.sort-expression.doc:550:0]

1 Reply
Not applicable
Author

please use this formula

wildmatch(Month_Name,'APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC','JAN','FEB','MAR')