Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

JustinDallas
Valued Contributor II

Sort Pivot Table value by clicking Column

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.

2017-06-06 12_13_38- Qlik Sense.png

Any help is greatly appreciated.

1 Solution

Accepted Solutions
robert99
Valued Contributor II

Re: Sort Pivot Table value by clicking Column

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.

3 Replies
robert99
Valued Contributor II

Re: Sort Pivot Table value by clicking Column

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
Valued Contributor II

Re: Sort Pivot Table value by clicking Column

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

robert99
Valued Contributor II

Re: Sort Pivot Table value by clicking Column

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.

Community Browser