topic Re: Sort by in expression list box in QlikView https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401364#M149355 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use sort by expression as</P><P>=SubField(FieldName,'-',2)</P></BODY></HTML> Mon, 03 Dec 2012 18:14:54 GMT CELAMBARASAN 2012-12-03T18:14:54Z Sort by in expression list box https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401363#M149354 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My list box is concatination of Numeric and text values Like:</P><P></P><P>5689-anvfgh</P><P>1002-gjkhk</P><P>455565656-tyhkjljkl</P><P></P><P>How can i do sort by A-Z on text value?</P></BODY></HTML> Mon, 03 Dec 2012 18:08:25 GMT https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401363#M149354 2012-12-03T18:08:25Z Re: Sort by in expression list box https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401364#M149355 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use sort by expression as</P><P>=SubField(FieldName,'-',2)</P></BODY></HTML> Mon, 03 Dec 2012 18:14:54 GMT https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401364#M149355 CELAMBARASAN 2012-12-03T18:14:54Z Re: Sort by in expression list box https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401365#M149356 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P> PFA</P><P></P><P>Edit:</P><P></P><P>Yes, Celambarasn gave the result .. sorry i didn't notice it.</P></BODY></HTML> Mon, 03 Dec 2012 18:19:00 GMT https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401365#M149356 MayilVahanan 2012-12-03T18:19:00Z Re: Sort by in expression list box https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401366#M149357 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="26390" class="jive-image-thumbnail jive-image" onclick="" alt="untitled.bmp" src="https://community.qlik.com/legacyfs/online/26390_untitled.bmp" width="450" /></P><P></P><P>pl see above img.</P><P></P><P>My Expression is Numerber &amp;'-'&amp; Text</P><P></P><P>i want to sort all tezt by A-Z regardless od numeric value</P></BODY></HTML> Mon, 03 Dec 2012 18:28:24 GMT https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401366#M149357 2012-12-03T18:28:24Z Re: Sort by in expression list box https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401367#M149358 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P> Can you post a sample file? Its helps to find a solution</P></BODY></HTML> Mon, 03 Dec 2012 18:47:38 GMT https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401367#M149358 MayilVahanan 2012-12-03T18:47:38Z Re: Sort by in expression list box https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401368#M149359 <HTML><HEAD></HEAD><BODY><P>Why not take care of this in the laod script.</P><P></P><P>Load </P><P>&nbsp;&nbsp;&nbsp;&nbsp; NumField &amp; '-' &amp; TextField as Field1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; NumField,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; TextField,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "</P><P></P><P>Then in your list box select the concatenated field Field1 as your dimension.&nbsp; In the sort tab use the TextField in the expression to use that as the sorting field.</P><P></P><P>Good luck</P><P>Oscar</P></BODY></HTML> Mon, 03 Dec 2012 20:33:52 GMT https://community.qlik.com/t5/QlikView/Sort-by-in-expression-list-box/m-p/401368#M149359 oscar_ortiz 2012-12-03T20:33:52Z