Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
please use this formula
wildmatch(Month_Name,'APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC','JAN','FEB','MAR')