Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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')