topic Re: Qlik Sort Order in QlikView https://community.qlik.com/t5/QlikView/Qlik-Sort-Order/m-p/1216974#M389659 <HTML><HEAD></HEAD><BODY><P>brilliant, cheers!</P></BODY></HTML> Fri, 17 Feb 2017 15:39:32 GMT wonkymeister 2017-02-17T15:39:32Z Qlik Sort Order https://community.qlik.com/t5/QlikView/Qlik-Sort-Order/m-p/1216972#M389657 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i need to sort a dimension - based on its values - twice. Is it possible?</P><P></P><P>i want to sort by:</P><P></P><P>value name in dimension = Department, and then A-Z</P><P></P><P>so:</P><P></P><P>Department</P><P>Alex</P><P>Brian</P><P>Claire</P><P>Dennis</P><P>Harold</P><P>etc...</P><P></P><P>Department has to come first, and everything else must be A-Z</P><P></P><P>any ideas guys?</P><P></P><P>Qlik 11.2, SR12</P></BODY></HTML> Fri, 17 Feb 2017 13:47:52 GMT https://community.qlik.com/t5/QlikView/Qlik-Sort-Order/m-p/1216972#M389657 wonkymeister 2017-02-17T13:47:52Z Re: Qlik Sort Order https://community.qlik.com/t5/QlikView/Qlik-Sort-Order/m-p/1216973#M389658 <HTML><HEAD></HEAD><BODY><P>May be like Sort by expression and then text</P><P></P><P>Expression sort using this</P><P><STRONG>Match(Dimension, 'Department', Dimension)</STRONG></P><P></P><P>Text sort</P><P><STRONG>A -&gt; Z</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/153523_Capture.PNG" style="height: 262px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Fri, 17 Feb 2017 13:49:38 GMT https://community.qlik.com/t5/QlikView/Qlik-Sort-Order/m-p/1216973#M389658 sunny_talwar 2017-02-17T13:49:38Z Re: Qlik Sort Order https://community.qlik.com/t5/QlikView/Qlik-Sort-Order/m-p/1216974#M389659 <HTML><HEAD></HEAD><BODY><P>brilliant, cheers!</P></BODY></HTML> Fri, 17 Feb 2017 15:39:32 GMT https://community.qlik.com/t5/QlikView/Qlik-Sort-Order/m-p/1216974#M389659 wonkymeister 2017-02-17T15:39:32Z