topic Re: sorting the list box values in QlikView https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778855#M276074 <HTML><HEAD></HEAD><BODY><P>See this screen shot</P></BODY></HTML> Thu, 06 Nov 2014 09:34:45 GMT sujeetsingh 2014-11-06T09:34:45Z sorting the list box values https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778852#M276071 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/70612_Capture.PNG.png" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>I have the year list box with the above year and Quarter format. now I need the sorting values of Quarter wise year i.e</P><P><IMG alt="Capture.PNG.png" class="jive-image" height="182" src="https://community.qlik.com/legacyfs/online/70611_Capture.PNG.png" style="width: 58px; height: 142px;" width="67" /></P><P>Suggest me on the same</P></BODY></HTML> Thu, 06 Nov 2014 09:31:50 GMT https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778852#M276071 Anonymous 2014-11-06T09:31:50Z Re: sorting the list box values https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778853#M276072 <HTML><HEAD></HEAD><BODY><P>Use num as well as text too</P></BODY></HTML> Thu, 06 Nov 2014 09:33:25 GMT https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778853#M276072 sujeetsingh 2014-11-06T09:33:25Z Re: sorting the list box values https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778854#M276073 <HTML><HEAD></HEAD><BODY><P>On the Sort tab of the List Box make sure &lt;Text&gt; is ticked and nothing else. </P></BODY></HTML> Thu, 06 Nov 2014 09:34:42 GMT https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778854#M276073 Anonymous 2014-11-06T09:34:42Z Re: sorting the list box values https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778855#M276074 <HTML><HEAD></HEAD><BODY><P>See this screen shot</P></BODY></HTML> Thu, 06 Nov 2014 09:34:45 GMT https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778855#M276074 sujeetsingh 2014-11-06T09:34:45Z Re: sorting the list box values https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778856#M276075 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Sort by "Text" should work. You can find this option in list box properties.</P></BODY></HTML> Thu, 06 Nov 2014 09:39:44 GMT https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778856#M276075 Anonymous 2014-11-06T09:39:44Z Re: sorting the list box values https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778857#M276076 <HTML><HEAD></HEAD><BODY><P>Suggest me out</P></BODY></HTML> Thu, 06 Nov 2014 10:00:49 GMT https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778857#M276076 Anonymous 2014-11-06T10:00:49Z Re: Re: sorting the list box values https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778858#M276077 <HTML><HEAD></HEAD><BODY><P>See attached qvw that works.</P></BODY></HTML> Thu, 06 Nov 2014 10:02:05 GMT https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778858#M276077 Anonymous 2014-11-06T10:02:05Z Re: sorting the list box values https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778859#M276078 <HTML><HEAD></HEAD><BODY><P>Go to Sort Tab of your List Box </P><P>Untick everything</P><P>Tick Expression and write below in your Expression</P><P>=TRIM(PurgeChar(Year,'Q'))</P></BODY></HTML> Thu, 06 Nov 2014 10:04:54 GMT https://community.qlik.com/t5/QlikView/sorting-the-list-box-values/m-p/778859#M276078 MK_QSL 2014-11-06T10:04:54Z