topic Re: Sorting a calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394543#M812347 <HTML><HEAD></HEAD><BODY><P>Do you have a date field? May be this</P><P></P><P>Max({1} Date)</P></BODY></HTML> Wed, 04 Oct 2017 15:39:38 GMT sunny_talwar 2017-10-04T15:39:38Z Sorting a calculated dimension https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394540#M812344 <HTML><HEAD></HEAD><BODY><P>I have the below columns in a pivot table from a single calculated dimension.</P><P></P><P>2Q 2016</P><P>3Q 2016</P><P>4Q 2016</P><P>1Q 2017</P><P></P><P>How do I sort them to be in above sequence? I get the below result when using <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Only</SPAN><SPAN style="font-size: 8pt;">({1} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Dim</SPAN><SPAN style="font-size: 8pt;">) </SPAN> in Sort tab =&gt; Expression</P><P>1Q 2017</P><P>2Q 2016</P><P>3Q 2016</P><P>4Q 2016</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394540#M812344 newqlik2017 2020-11-25T16:16:04Z Re: Sorting a calculated dimension https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394541#M812345 <HTML><HEAD></HEAD><BODY><P>Hi use in expression</P><P></P><P>right(Dim,4)*1000+left(Dim,1)</P><P></P><P>and sort in Ascending order</P><P></P><P>Regards<BR />Pratyush</P></BODY></HTML> Wed, 04 Oct 2017 15:20:02 GMT https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394541#M812345 prat1507 2017-10-04T15:20:02Z Re: Sorting a calculated dimension https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394542#M812346 <HTML><HEAD></HEAD><BODY><P>If you have a Date column, you an use that in sort expression and sort in Ascending Order</P></BODY></HTML> Wed, 04 Oct 2017 15:20:39 GMT https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394542#M812346 krishnacbe 2017-10-04T15:20:39Z Re: Sorting a calculated dimension https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394543#M812347 <HTML><HEAD></HEAD><BODY><P>Do you have a date field? May be this</P><P></P><P>Max({1} Date)</P></BODY></HTML> Wed, 04 Oct 2017 15:39:38 GMT https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394543#M812347 sunny_talwar 2017-10-04T15:39:38Z Re: Sorting a calculated dimension https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394544#M812348 <HTML><HEAD></HEAD><BODY><P>That worked, Sunny. Thank you.</P></BODY></HTML> Wed, 04 Oct 2017 17:31:03 GMT https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimension/m-p/1394544#M812348 newqlik2017 2017-10-04T17:31:03Z