topic Re: Problem with sorting by expression in pivot table in QlikView https://community.qlik.com/t5/QlikView/Problem-with-sorting-by-expression-in-pivot-table/m-p/428690#M566955 <HTML><HEAD></HEAD><BODY><P>Pivot tables are a pest when it comes to sorting on anything but numeric or text. If at all possible use a straight table instead. Pivot tables don't have interactive sort either.</P></BODY></HTML> Wed, 12 Dec 2012 12:53:03 GMT Gysbert_Wassenaar 2012-12-12T12:53:03Z Problem with sorting by expression in pivot table https://community.qlik.com/t5/QlikView/Problem-with-sorting-by-expression-in-pivot-table/m-p/428688#M566953 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table that consists of 5 dimensions and a couple of expressions... I have 2 dimensions expanded by default which are sorted properly by alphabetical order.</P><P></P><P>I have some problems with my other 3 dimensions, which I want to sort descending by sum(Sales), that is one of my expressions in the same pivot table. Why can't I get this work? (image attached, it's the corrent dimension - swedish)</P><P></P><P>Also, I would like to know if it is possible to sort interactive in a QlikView pivot table? So that I can switch between descending and ascending in the column head...</P><P></P><P>Thanks in advance!</P><P></P><P>Best,</P><P>Filip</P></BODY></HTML> Wed, 12 Dec 2012 07:52:25 GMT https://community.qlik.com/t5/QlikView/Problem-with-sorting-by-expression-in-pivot-table/m-p/428688#M566953 Anonymous 2012-12-12T07:52:25Z Re: Problem with sorting by expression in pivot table https://community.qlik.com/t5/QlikView/Problem-with-sorting-by-expression-in-pivot-table/m-p/428689#M566954 <HTML><HEAD></HEAD><BODY><P>And if you wonder about the typing format, I use another expression that is confidential, that's why I wrote "Sales", which is not a field in my data model.</P></BODY></HTML> Wed, 12 Dec 2012 07:54:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-sorting-by-expression-in-pivot-table/m-p/428689#M566954 Anonymous 2012-12-12T07:54:42Z Re: Problem with sorting by expression in pivot table https://community.qlik.com/t5/QlikView/Problem-with-sorting-by-expression-in-pivot-table/m-p/428690#M566955 <HTML><HEAD></HEAD><BODY><P>Pivot tables are a pest when it comes to sorting on anything but numeric or text. If at all possible use a straight table instead. Pivot tables don't have interactive sort either.</P></BODY></HTML> Wed, 12 Dec 2012 12:53:03 GMT https://community.qlik.com/t5/QlikView/Problem-with-sorting-by-expression-in-pivot-table/m-p/428690#M566955 Gysbert_Wassenaar 2012-12-12T12:53:03Z