topic custom sort expression in QlikView https://community.qlik.com/t5/QlikView/custom-sort-expression/m-p/235527#M86783 <HTML><HEAD></HEAD><BODY><P>please use this formula</P><P></P><P>wildmatch<B>(</B>Month_Name,'APR'<B>,</B>'MAY'<B>,</B>'JUN'<B>,</B>'JUL'<B>,</B>'AUG'<B>,</B>'SEP'<B>,</B>'OCT'<B>,</B>'NOV'<B>,</B>'DEC'<B>,</B>'JAN'<B>,</B>'FEB'<B>,</B>'MAR')</P><P style="font-weight: bold"></P><BR /><BR /> <P></P><P></P><BR /><BR /> <BR /><BR /> <P></P></BODY></HTML> Mon, 09 Nov 2009 11:38:46 GMT 2009-11-09T11:38:46Z custom sort expression https://community.qlik.com/t5/QlikView/custom-sort-expression/m-p/235526#M86782 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P>How do I do this?</P><P>Thanks</P><P>David</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3731.sort-expression.doc:550:0]</P><P></P></BODY></HTML> Mon, 09 Nov 2009 09:58:36 GMT https://community.qlik.com/t5/QlikView/custom-sort-expression/m-p/235526#M86782 2009-11-09T09:58:36Z custom sort expression https://community.qlik.com/t5/QlikView/custom-sort-expression/m-p/235527#M86783 <HTML><HEAD></HEAD><BODY><P>please use this formula</P><P></P><P>wildmatch<B>(</B>Month_Name,'APR'<B>,</B>'MAY'<B>,</B>'JUN'<B>,</B>'JUL'<B>,</B>'AUG'<B>,</B>'SEP'<B>,</B>'OCT'<B>,</B>'NOV'<B>,</B>'DEC'<B>,</B>'JAN'<B>,</B>'FEB'<B>,</B>'MAR')</P><P style="font-weight: bold"></P><BR /><BR /> <P></P><P></P><BR /><BR /> <BR /><BR /> <P></P></BODY></HTML> Mon, 09 Nov 2009 11:38:46 GMT https://community.qlik.com/t5/QlikView/custom-sort-expression/m-p/235527#M86783 2009-11-09T11:38:46Z