topic Re: Sort by Expression in QlikView https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479144#M483151 <HTML><HEAD></HEAD><BODY><P>Thank you swuehl..that worked well...</P></BODY></HTML> Mon, 15 Jul 2013 09:29:42 GMT 2013-07-15T09:29:42Z Sort by Expression https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479140#M483147 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a list-box with some text values from the database. I am using an expression = Capitalize (Field) to get the correct format.</P><P>Now, when I go to Sort-&gt;Expression and Paste the same expression as above and put it to Ascending, I am not getting the Field sorted based on Alphabetical order. How can that be achieved?</P></BODY></HTML> Mon, 15 Jul 2013 09:01:15 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479140#M483147 2013-07-15T09:01:15Z Re: Sort by Expression https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479141#M483148 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; What is the order which it is showing, will you please share the example of what is expected and what it is showing.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 15 Jul 2013 09:02:50 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479141#M483148 kaushiknsolanki 2013-07-15T09:02:50Z Re: Sort by Expression https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479142#M483149 <HTML><HEAD></HEAD><BODY><P>Properties . sort &gt; check "A-Z"&nbsp;&nbsp; &amp; uncheck expression</P><P></P><P>otherwise check load order "Original"</P></BODY></HTML> Mon, 15 Jul 2013 09:05:17 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479142#M483149 2013-07-15T09:05:17Z Re: Sort by Expression https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479143#M483150 <HTML><HEAD></HEAD><BODY><P>Try correcting your correct format in the script</P><P></P><P>LOAD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Capitalize(FIELD) as FIELD,</P><P>....</P><P></P><P>then use alphabetical sort order in your list box.</P></BODY></HTML> Mon, 15 Jul 2013 09:05:40 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479143#M483150 swuehl 2013-07-15T09:05:40Z Re: Sort by Expression https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479144#M483151 <HTML><HEAD></HEAD><BODY><P>Thank you swuehl..that worked well...</P></BODY></HTML> Mon, 15 Jul 2013 09:29:42 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/479144#M483151 2013-07-15T09:29:42Z