topic custom sorting on last 12 months in QlikView https://community.qlik.com/t5/QlikView/custom-sorting-on-last-12-months/m-p/934376#M322708 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>How do we sort last 12 months in bar chart.</P><P>ex:</P><P>201409</P><P>201410</P><P>201411</P><P>201412</P><P>201501</P><P>201502</P><P>'</P><P>'</P><P>'</P><P></P><P>thanks</P></BODY></HTML> Fri, 11 Sep 2015 14:28:33 GMT grajmca_sgp123 2015-09-11T14:28:33Z custom sorting on last 12 months https://community.qlik.com/t5/QlikView/custom-sorting-on-last-12-months/m-p/934376#M322708 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>How do we sort last 12 months in bar chart.</P><P>ex:</P><P>201409</P><P>201410</P><P>201411</P><P>201412</P><P>201501</P><P>201502</P><P>'</P><P>'</P><P>'</P><P></P><P>thanks</P></BODY></HTML> Fri, 11 Sep 2015 14:28:33 GMT https://community.qlik.com/t5/QlikView/custom-sorting-on-last-12-months/m-p/934376#M322708 grajmca_sgp123 2015-09-11T14:28:33Z Re: custom sorting on last 12 months https://community.qlik.com/t5/QlikView/custom-sorting-on-last-12-months/m-p/934377#M322709 <HTML><HEAD></HEAD><BODY><P>May be use Expression to sort it ascending or descending and expression would be:</P><P></P><P><STRONG>Date#(YearMonthFieldName, 'YYYYMM')</STRONG></P></BODY></HTML> Fri, 11 Sep 2015 14:29:58 GMT https://community.qlik.com/t5/QlikView/custom-sorting-on-last-12-months/m-p/934377#M322709 sunny_talwar 2015-09-11T14:29:58Z Re: custom sorting on last 12 months https://community.qlik.com/t5/QlikView/custom-sorting-on-last-12-months/m-p/934378#M322710 <HTML><HEAD></HEAD><BODY><P>in sort tab and sort by text or number</P><P></P><P>or if you want a custom order in expression</P><P>wildmatch(yourfield,201409,201410,........,'*')</P></BODY></HTML> Fri, 11 Sep 2015 14:45:41 GMT https://community.qlik.com/t5/QlikView/custom-sorting-on-last-12-months/m-p/934378#M322710 maxgro 2015-09-11T14:45:41Z