topic Re: Custom sort list box in QlikView https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348466#M414792 <HTML><HEAD></HEAD><BODY><P>May be try a sort expression like this</P><P></P><P><STRONG>Only({1} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[Product Description]</SPAN>)</STRONG></P><P></P><P>and select ascending</P></BODY></HTML> Wed, 05 Apr 2017 14:10:34 GMT sunny_talwar 2017-04-05T14:10:34Z Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348465#M414791 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a list box created with an expression =[Product ID] &amp; ' - ' &amp; [Product Description] that has values like</P><P></P><P>001 - abc</P><P>123 - bcs</P><P>234 - 276</P><P></P><P>I want to sort the list box by the product Description in ascending order. Kindly suggest!</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 05 Apr 2017 14:09:07 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348465#M414791 2017-04-05T14:09:07Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348466#M414792 <HTML><HEAD></HEAD><BODY><P>May be try a sort expression like this</P><P></P><P><STRONG>Only({1} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[Product Description]</SPAN>)</STRONG></P><P></P><P>and select ascending</P></BODY></HTML> Wed, 05 Apr 2017 14:10:34 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348466#M414792 sunny_talwar 2017-04-05T14:10:34Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348467#M414793 <HTML><HEAD></HEAD><BODY><P>Did not work</P></BODY></HTML> Wed, 05 Apr 2017 14:15:13 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348467#M414793 2017-04-05T14:15:13Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348468#M414794 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample where this isn't working?</P></BODY></HTML> Wed, 05 Apr 2017 14:16:28 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348468#M414794 sunny_talwar 2017-04-05T14:16:28Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348469#M414795 <HTML><HEAD></HEAD><BODY><P>I have attached a sample.</P></BODY></HTML> Wed, 05 Apr 2017 14:24:51 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348469#M414795 2017-04-05T14:24:51Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348470#M414796 <HTML><HEAD></HEAD><BODY><P>Can you do like </P><P>= ProductDescription &amp; '-' &amp; [Product ID]</P><P></P><P>Then Sort tab -&gt; Check Text - A-Z. </P><P></P><P>Will that work? </P></BODY></HTML> Wed, 05 Apr 2017 14:42:45 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348470#M414796 vishsaggi 2017-04-05T14:42:45Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348471#M414797 <HTML><HEAD></HEAD><BODY><P>Does not work</P></BODY></HTML> Wed, 05 Apr 2017 14:52:43 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348471#M414797 2017-04-05T14:52:43Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348472#M414798 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Rank(Only({1} [ProductDescription]))</STRONG></P><P></P><P>With Descending sort</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159143_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 05 Apr 2017 15:05:29 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348472#M414798 sunny_talwar 2017-04-05T15:05:29Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348473#M414799 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny. This is correct!</P></BODY></HTML> Wed, 05 Apr 2017 15:07:41 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348473#M414799 2017-04-05T15:07:41Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348474#M414800 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny, its been long go I have used something like Rank in sort. Thanks for refreshing memory. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Wed, 05 Apr 2017 15:12:17 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348474#M414800 vishsaggi 2017-04-05T15:12:17Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348475#M414801 <HTML><HEAD></HEAD><BODY><P>Sunny, can you explain me why have you sorted the Rank function in descending order rather than ascending?</P></BODY></HTML> Wed, 05 Apr 2017 19:16:53 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348475#M414801 2017-04-05T19:16:53Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348476#M414802 <HTML><HEAD></HEAD><BODY><P>Rank function will give a rank 1 to something beginning with Z, rather than something beginning with A.... So to make Z the last, I will have to do descending sort order, right?</P></BODY></HTML> Wed, 05 Apr 2017 19:18:02 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348476#M414802 sunny_talwar 2017-04-05T19:18:02Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348477#M414803 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny.</P></BODY></HTML> Wed, 05 Apr 2017 19:19:10 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348477#M414803 2017-04-05T19:19:10Z Re: Custom sort list box https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348478#M414804 <HTML><HEAD></HEAD><BODY><P>Yup, no problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 05 Apr 2017 19:20:01 GMT https://community.qlik.com/t5/QlikView/Custom-sort-list-box/m-p/1348478#M414804 sunny_talwar 2017-04-05T19:20:01Z