Sort Pivot Table value by clicking Column

[JustinDallas]

Hello Everyone,

I've created a Pivot table as can be seen in the image below.  My client would like to be able to sort on the Measure within the application.  Is there a way they can do this through clicking the headers?  Right now, the hearders mainly function as Dimension Value Selectors, and not in the same way they might function as in an Excel file or an HTML Table.

Any help is greatly appreciated.

[robert99]

Hi Justin

You can't do this with the pivot Table. Sorting is pre-set. By alpha, expression or number.

It can be done using a straight table though. But you would need to set up an expression for the required months (which I often do as I prefer the user to have the choice of sorting as required)

[JustinDallas]

Would a Straight Table allow me to have breakouts by month?  I'm only seeing Dims and Measures, nowhere to put a column.

[robert99 · Accepted solution]

The way I do this is to have 12 expressions one for every month. That's the only way it can be done at present.

[gthuiz]

Is this "click on a column to sort" feature currently being developed?  This is my biggest pain point with QlikSense, and it would make my life a lot better if the pivot table would work like this.