topic SORT PROPERTIES in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/SORT-PROPERTIES/m-p/782198#M2086 <HTML><HEAD></HEAD><BODY><P>hi !!</P><P>could anyone help me with the sort properties?</P><P>i have attached an excel file with my issue..</P><P>you see i want to sort&nbsp; some sizes in order because qlick sawing them to me a little bit <SPAN class="short_text" lang="en"><SPAN class="hps">stirred</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">qlick saws (14,15,16,14H,15H,16H) and i want (14,14H,15,15H,16,16H)</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">is there an expression for this???</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">thank you!<BR /></SPAN></SPAN></P></BODY></HTML> Thu, 06 Nov 2014 15:07:25 GMT 2014-11-06T15:07:25Z SORT PROPERTIES https://community.qlik.com/t5/Qlik-Learning-Discussions/SORT-PROPERTIES/m-p/782198#M2086 <HTML><HEAD></HEAD><BODY><P>hi !!</P><P>could anyone help me with the sort properties?</P><P>i have attached an excel file with my issue..</P><P>you see i want to sort&nbsp; some sizes in order because qlick sawing them to me a little bit <SPAN class="short_text" lang="en"><SPAN class="hps">stirred</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">qlick saws (14,15,16,14H,15H,16H) and i want (14,14H,15,15H,16,16H)</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">is there an expression for this???</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">thank you!<BR /></SPAN></SPAN></P></BODY></HTML> Thu, 06 Nov 2014 15:07:25 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/SORT-PROPERTIES/m-p/782198#M2086 2014-11-06T15:07:25Z Re: SORT PROPERTIES https://community.qlik.com/t5/Qlik-Learning-Discussions/SORT-PROPERTIES/m-p/782199#M2087 <HTML><HEAD></HEAD><BODY><P>In sort tab check the sort by expression only and use something like</P><P>=KeepChar(SIZEDESCR,'0123456789')</P></BODY></HTML> Thu, 06 Nov 2014 15:20:01 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/SORT-PROPERTIES/m-p/782199#M2087 stigchel 2014-11-06T15:20:01Z Re: SORT PROPERTIES https://community.qlik.com/t5/Qlik-Learning-Discussions/SORT-PROPERTIES/m-p/782200#M2088 <HTML><HEAD></HEAD><BODY><P>thank you very much!!</P></BODY></HTML> Thu, 06 Nov 2014 15:24:22 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/SORT-PROPERTIES/m-p/782200#M2088 2014-11-06T15:24:22Z Re: SORT PROPERTIES https://community.qlik.com/t5/Qlik-Learning-Discussions/SORT-PROPERTIES/m-p/782201#M2089 <HTML><HEAD></HEAD><BODY><P>You're welcome. if you found my solution correct, could you mark my answer as correct? This way the thread is closed, so others know no more help is required. Also others with a similar problem might find a solution to their problem easier.</P></BODY></HTML> Thu, 06 Nov 2014 15:29:42 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/SORT-PROPERTIES/m-p/782201#M2089 stigchel 2014-11-06T15:29:42Z