topic Re: How to order pivotable in QlikView https://community.qlik.com/t5/QlikView/How-to-order-pivotable/m-p/533743#M1302560 <HTML><HEAD></HEAD><BODY><P>Hi, in the sort tab you could set establishment as first dimension and set sort by text A-Z</P><P>Then you have to write an expression to sort the category by price billed.</P></BODY></HTML> Wed, 09 Oct 2013 13:27:47 GMT bbi_mba_76 2013-10-09T13:27:47Z How to order pivotable https://community.qlik.com/t5/QlikView/How-to-order-pivotable/m-p/533742#M1302557 <HTML><HEAD></HEAD><BODY><P>I have a PivotTable with dimensions states, Establishment, Category, Product Unit and in that order, and an expression Value billed.</P><P>I would like to order the establishment of the text itself (exemple: 001, 002, 003) and from category to sort by price billed.</P><P></P><P></P><P>exemple: State - 001 - CATEG03 - 50,000</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CATEG01 - 8000</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CATEG50 - 2000</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 002...</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/How-to-order-pivotable/m-p/533742#M1302557 2026-01-26T18:19:17Z Re: How to order pivotable https://community.qlik.com/t5/QlikView/How-to-order-pivotable/m-p/533743#M1302560 <HTML><HEAD></HEAD><BODY><P>Hi, in the sort tab you could set establishment as first dimension and set sort by text A-Z</P><P>Then you have to write an expression to sort the category by price billed.</P></BODY></HTML> Wed, 09 Oct 2013 13:27:47 GMT https://community.qlik.com/t5/QlikView/How-to-order-pivotable/m-p/533743#M1302560 bbi_mba_76 2013-10-09T13:27:47Z Re: How to order pivotable https://community.qlik.com/t5/QlikView/How-to-order-pivotable/m-p/533744#M1302562 <HTML><HEAD></HEAD><BODY><P>thanks for the help.</P></BODY></HTML> Wed, 09 Oct 2013 14:10:04 GMT https://community.qlik.com/t5/QlikView/How-to-order-pivotable/m-p/533744#M1302562 2013-10-09T14:10:04Z