2 Replies Latest reply: Dec 12, 2012 7:58 AM by Gysbert Wassenaar RSS

    Problem with sorting by expression in pivot table

    Filip Larsson

      Hi,

       

      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.

       

      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)

       

      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...

       

      Thanks in advance!

       

      Best,

      Filip