topic Re: How to sort concatenated field in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-concatenated-field/m-p/1189817#M883908 <HTML><HEAD></HEAD><BODY><OL><LI>Check Expression box- Add only <SPAN style="font-size: 13.3333px;">'Year' </SPAN>field and select sort by Descending.</LI><LI>Along with this Check Text box and Sort order 'Z-&gt;A'</LI></OL><P>Let us know if this works.</P></BODY></HTML> Wed, 08 Feb 2017 07:50:42 GMT Anonymous 2017-02-08T07:50:42Z How to sort concatenated field https://community.qlik.com/t5/QlikView/How-to-sort-concatenated-field/m-p/1189815#M883906 <HTML><HEAD></HEAD><BODY><P>Hello there,</P><P></P><P>I created a field called QuarterYear where I concatenated the Quarter &amp; year fields. I now want to display this field in an descending order i.e. I want it to be sorted as Q4-2016 <SPAN style="font-size: 13.3333px;">Q3-2016&nbsp; <SPAN style="font-size: 13.3333px;">Q2-2016 <SPAN style="font-size: 13.3333px;">Q1-2016 <SPAN style="font-size: 13.3333px;">Q4-2015 <SPAN style="font-size: 13.3333px;">Q3-2015&nbsp; etc. How should I go about this?</SPAN></SPAN></SPAN></SPAN></SPAN></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-sort-concatenated-field/m-p/1189815#M883906 2020-11-25T16:16:04Z Re: How to sort concatenated field https://community.qlik.com/t5/QlikView/How-to-sort-concatenated-field/m-p/1189816#M883907 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">I've had success by sorting by the expression:</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Quarter</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Custom Sort<BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Sort by Expression<BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P></P><P>Quarter &amp; '-' &amp; Year </P><P></P><P>Descending Order</P></BODY></HTML> Thu, 22 Dec 2016 16:59:07 GMT https://community.qlik.com/t5/QlikView/How-to-sort-concatenated-field/m-p/1189816#M883907 gamaescalante 2016-12-22T16:59:07Z Re: How to sort concatenated field https://community.qlik.com/t5/QlikView/How-to-sort-concatenated-field/m-p/1189817#M883908 <HTML><HEAD></HEAD><BODY><OL><LI>Check Expression box- Add only <SPAN style="font-size: 13.3333px;">'Year' </SPAN>field and select sort by Descending.</LI><LI>Along with this Check Text box and Sort order 'Z-&gt;A'</LI></OL><P>Let us know if this works.</P></BODY></HTML> Wed, 08 Feb 2017 07:50:42 GMT https://community.qlik.com/t5/QlikView/How-to-sort-concatenated-field/m-p/1189817#M883908 Anonymous 2017-02-08T07:50:42Z Re: How to sort concatenated field https://community.qlik.com/t5/QlikView/How-to-sort-concatenated-field/m-p/1189818#M883909 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In the Sort tab, please check the 'sort by expression' and uncheck rest of the options.</P><P>Use the expression: </P><P><STRONG>=Right([Your_Field],4)&amp;mid([<SPAN style="font-size: 13.3333px;">Your_Field</SPAN>],2,1)</STRONG></P><P></P><P>From the dropdown choose 'ascending' or 'descending' according to your need. It should work.</P></BODY></HTML> Wed, 08 Feb 2017 08:18:56 GMT https://community.qlik.com/t5/QlikView/How-to-sort-concatenated-field/m-p/1189818#M883909 2017-02-08T08:18:56Z