topic Sorting in pivot table in QlikView https://community.qlik.com/t5/QlikView/Sorting-in-pivot-table/m-p/665026#M1064848 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with one dimension which is a variable. The dimension changes when appropriate text boxes (select in field action) is selected. The tricky part is I need to sort the dimension in different order depending on what the dimension is.</P><P></P><P>How can this be achieved?</P><P></P><P>Koushik </P></BODY></HTML> Wed, 10 Sep 2014 09:46:15 GMT 2014-09-10T09:46:15Z Sorting in pivot table https://community.qlik.com/t5/QlikView/Sorting-in-pivot-table/m-p/665026#M1064848 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with one dimension which is a variable. The dimension changes when appropriate text boxes (select in field action) is selected. The tricky part is I need to sort the dimension in different order depending on what the dimension is.</P><P></P><P>How can this be achieved?</P><P></P><P>Koushik </P></BODY></HTML> Wed, 10 Sep 2014 09:46:15 GMT https://community.qlik.com/t5/QlikView/Sorting-in-pivot-table/m-p/665026#M1064848 2014-09-10T09:46:15Z Re: Sorting in pivot table https://community.qlik.com/t5/QlikView/Sorting-in-pivot-table/m-p/665027#M1064849 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi Koushik,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Have you tried using the "Sort by Expression" and use the variable with Dollar Sign Expansion? So you can set the variable with new content every time it's new Dimension.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">www.QlikShare.com</SPAN></P></BODY></HTML> Wed, 10 Sep 2014 09:50:52 GMT https://community.qlik.com/t5/QlikView/Sorting-in-pivot-table/m-p/665027#M1064849 IAMDV 2014-09-10T09:50:52Z Re: Sorting in pivot table https://community.qlik.com/t5/QlikView/Sorting-in-pivot-table/m-p/665028#M1064850 <HTML><HEAD></HEAD><BODY><P>Lets say in first instance vDimension is MonthYear and in the second instance its SalesPerson. I want to sort MonthYear by Descending order and SalesPerson by alphabetical order?</P></BODY></HTML> Wed, 10 Sep 2014 09:58:50 GMT https://community.qlik.com/t5/QlikView/Sorting-in-pivot-table/m-p/665028#M1064850 2014-09-10T09:58:50Z Re: Re: Sorting in pivot table https://community.qlik.com/t5/QlikView/Sorting-in-pivot-table/m-p/665029#M1064851 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Yes, it's possible. As I said earlier, try using the variables within the expression sorting or p</SPAN><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt; line-height: 1.5em;">ost a sample QVW file and I'll mock up an example for you.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">www.QlikShare.com</SPAN></P></BODY></HTML> Wed, 10 Sep 2014 10:30:22 GMT https://community.qlik.com/t5/QlikView/Sorting-in-pivot-table/m-p/665029#M1064851 IAMDV 2014-09-10T10:30:22Z