topic Pivot Table Sorting in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Sorting/m-p/648257#M1056361 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Has anyone figured this out yet? How to sort a pivot table at an expression level in context of a table row. I have a simple pivot table attached and would like to sort each store by its category quantities.</P></BODY></HTML> Thu, 16 Oct 2014 19:48:54 GMT 2014-10-16T19:48:54Z Pivot Table Sorting https://community.qlik.com/t5/QlikView/Pivot-Table-Sorting/m-p/648257#M1056361 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Has anyone figured this out yet? How to sort a pivot table at an expression level in context of a table row. I have a simple pivot table attached and would like to sort each store by its category quantities.</P></BODY></HTML> Thu, 16 Oct 2014 19:48:54 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Sorting/m-p/648257#M1056361 2014-10-16T19:48:54Z Re: Pivot Table Sorting https://community.qlik.com/t5/QlikView/Pivot-Table-Sorting/m-p/648258#M1056362 <HTML><HEAD></HEAD><BODY><P>You can't sort one dimension in two ways. So sorting by expression won't work afaik. You can use a straight table or add a calculated dimension to the pivot table and sort by that calculated dimension. You could also sort the Store dimension by Y-value, but that will not only sort the category dimension, but the Store dimension as well. </P></BODY></HTML> Fri, 17 Oct 2014 09:49:45 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Sorting/m-p/648258#M1056362 Gysbert_Wassenaar 2014-10-17T09:49:45Z