topic how to sort the data by the expression in ListBox in QlikView https://community.qlik.com/t5/QlikView/how-to-sort-the-data-by-the-expression-in-ListBox/m-p/344045#M127031 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: 0.0001pt;"><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt;">test:</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt;"><STRONG><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt;">load</SPAN></STRONG><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt;"> * </SPAN><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt;">Inline</SPAN> <SPAN lang="EN-US" style="color: maroon; font-family: 'Courier New'; font-size: 9pt;">[<BR />customer<BR />00010 BBBBB<BR />00020 CCCCC<BR />00030 AAAAA<BR />00040 DDDDD<BR />]</SPAN>;&nbsp; </SPAN></P><P></P><P><SPAN class="hps">I want to</SPAN> <SPAN class="hps">get:</SPAN></P><P></P><P><SPAN class="hps">00030&nbsp; AAAAA</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN class="hps">00010&nbsp; BBBBB</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN class="hps">00020&nbsp; CCCCC</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN class="hps">00040&nbsp; DDDDD<BR /></SPAN></P></BODY></HTML> Tue, 10 Apr 2012 08:13:38 GMT 2012-04-10T08:13:38Z how to sort the data by the expression in ListBox https://community.qlik.com/t5/QlikView/how-to-sort-the-data-by-the-expression-in-ListBox/m-p/344045#M127031 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: 0.0001pt;"><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt;">test:</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt;"><STRONG><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt;">load</SPAN></STRONG><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt;"> * </SPAN><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt;">Inline</SPAN> <SPAN lang="EN-US" style="color: maroon; font-family: 'Courier New'; font-size: 9pt;">[<BR />customer<BR />00010 BBBBB<BR />00020 CCCCC<BR />00030 AAAAA<BR />00040 DDDDD<BR />]</SPAN>;&nbsp; </SPAN></P><P></P><P><SPAN class="hps">I want to</SPAN> <SPAN class="hps">get:</SPAN></P><P></P><P><SPAN class="hps">00030&nbsp; AAAAA</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN class="hps">00010&nbsp; BBBBB</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN class="hps">00020&nbsp; CCCCC</SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN class="hps">00040&nbsp; DDDDD<BR /></SPAN></P></BODY></HTML> Tue, 10 Apr 2012 08:13:38 GMT https://community.qlik.com/t5/QlikView/how-to-sort-the-data-by-the-expression-in-ListBox/m-p/344045#M127031 2012-04-10T08:13:38Z how to sort the data by the expression in ListBox https://community.qlik.com/t5/QlikView/how-to-sort-the-data-by-the-expression-in-ListBox/m-p/344046#M127032 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ListBox Properties--&gt;Sort tab--&gt;Sort by expression as =Rank(SubField(customer,' ',2))</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 10 Apr 2012 08:42:51 GMT https://community.qlik.com/t5/QlikView/how-to-sort-the-data-by-the-expression-in-ListBox/m-p/344046#M127032 CELAMBARASAN 2012-04-10T08:42:51Z how to sort the data by the expression in ListBox https://community.qlik.com/t5/QlikView/how-to-sort-the-data-by-the-expression-in-ListBox/m-p/344047#M127033 <HTML><HEAD></HEAD><BODY><P>Thanks, is OK</P></BODY></HTML> Tue, 10 Apr 2012 09:07:04 GMT https://community.qlik.com/t5/QlikView/how-to-sort-the-data-by-the-expression-in-ListBox/m-p/344047#M127033 2012-04-10T09:07:04Z