Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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')