topic Sorting in QlikView https://community.qlik.com/t5/QlikView/Sorting/m-p/674466#M244895 <HTML><HEAD></HEAD><BODY><P>how do i sort the following using an expression?/</P><P></P><P>Client Declined</P><P>Bound</P><P>Underwriter Declined</P><P>Missed</P><P>Lost</P><P>Out of Scope</P></BODY></HTML> Wed, 13 Aug 2014 13:12:56 GMT kevbrown 2014-08-13T13:12:56Z Sorting https://community.qlik.com/t5/QlikView/Sorting/m-p/674466#M244895 <HTML><HEAD></HEAD><BODY><P>how do i sort the following using an expression?/</P><P></P><P>Client Declined</P><P>Bound</P><P>Underwriter Declined</P><P>Missed</P><P>Lost</P><P>Out of Scope</P></BODY></HTML> Wed, 13 Aug 2014 13:12:56 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/674466#M244895 kevbrown 2014-08-13T13:12:56Z Re: Sorting https://community.qlik.com/t5/QlikView/Sorting/m-p/674467#M244896 <HTML><HEAD></HEAD><BODY><P>Hi Kevin,</P><P></P><P>In the chart properties you can sort on expressions:</P><P><IMG alt="Screen Shot 2014-08-13 at 9.25.36.png" class="jive-image" src="/legacyfs/online/64330_Screen Shot 2014-08-13 at 9.25.36.png" style="width: 620px; height: 392px;" /></P><P></P><P>You'll need to decide what expression you want to sort on, e.g. count(Lost) or count(Missed), etc, and enter it in the expression box.</P><P></P><P>Hope that helps.</P><P></P><P>Matt</P></BODY></HTML> Wed, 13 Aug 2014 13:27:58 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/674467#M244896 2014-08-13T13:27:58Z Re: Sorting https://community.qlik.com/t5/QlikView/Sorting/m-p/674468#M244897 <HTML><HEAD></HEAD><BODY><P>Hi Kevin</P><P>you can sort this using Match(yourfield, 'Client Declined','Bound','Underwriter Declined','Missed') whatever order you like</P><P></P><P>Thanks</P><P>Padma</P></BODY></HTML> Wed, 13 Aug 2014 13:42:26 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/674468#M244897 qlikoqlik 2014-08-13T13:42:26Z