topic Re: sort pivot in QlikView https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917624#M318117 <HTML><HEAD></HEAD><BODY><P>Go to propreties and select Sort tab.</P><P></P><P>you will have options in dimensions window to choose.</P><P></P><P>John</P></BODY></HTML> Tue, 11 Aug 2015 03:08:29 GMT john9inno 2015-08-11T03:08:29Z sort pivot https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917623#M318116 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>i made calculte dimansion with 2 feilds "q &amp;'-'&amp; year"</P><P>i want to sort pivot table by this demansion , exm :</P><P>q1-2014, q2-2014,q3-2014,q4-2014,q1-2015,q2-2015....</P><P></P><P>how to do it ?</P><P></P><P>thanks'</P><P>yarin.</P></BODY></HTML> Tue, 11 Aug 2015 03:04:25 GMT https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917623#M318116 Anonymous 2015-08-11T03:04:25Z Re: sort pivot https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917624#M318117 <HTML><HEAD></HEAD><BODY><P>Go to propreties and select Sort tab.</P><P></P><P>you will have options in dimensions window to choose.</P><P></P><P>John</P></BODY></HTML> Tue, 11 Aug 2015 03:08:29 GMT https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917624#M318117 john9inno 2015-08-11T03:08:29Z Re: sort pivot https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917625#M318118 <HTML><HEAD></HEAD><BODY><P><IMG alt="QV.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95586_QV.jpg" style="width: 620px; height: 349px;" /><BR />use the source data field to sort the data.</P><P></P><P>however, adding that quater field at load could perform quicker when data size is not small.</P></BODY></HTML> Tue, 11 Aug 2015 03:18:34 GMT https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917625#M318118 john9inno 2015-08-11T03:18:34Z Re: sort pivot https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917626#M318119 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please go through this thread:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-7220">Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)</A></P><P></P><P>Hope it will helpful!!</P></BODY></HTML> Tue, 11 Aug 2015 03:23:29 GMT https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917626#M318119 Anonymous 2015-08-11T03:23:29Z Re: sort pivot https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917627#M318120 <HTML><HEAD></HEAD><BODY><P>You can use "expression" on label order and put year&amp;quarter</P></BODY></HTML> Tue, 11 Aug 2015 03:23:59 GMT https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917627#M318120 ecolomer 2015-08-11T03:23:59Z Re: sort pivot https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917628#M318121 <HTML><HEAD></HEAD><BODY><P>Try this as your calculated Dimensions:</P><P></P><P><STRONG>Dual(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Quarter &amp; '-' &amp; Year, Num#(Year &amp; Right(Quarter, 1), '##'))</STRONG></SPAN></P><P></P><P>and then sort your calculated dimension by ascending or descending based on your requirement.</P><P></P><P>Edit: Assuming Quarter contain values like this -&gt; Q1, Q2, Q3, Q4</P></BODY></HTML> Tue, 11 Aug 2015 03:27:03 GMT https://community.qlik.com/t5/QlikView/sort-pivot/m-p/917628#M318121 sunny_talwar 2015-08-11T03:27:03Z