Sorting within a Pivot Table with multiple dimensions and multiple measures

[#1]

Hi,

I am building a chart in Qlik Sense 3.1 that contains a pivot table with multiple dimensions as rows and multiple measures as columns. Currently the values of each dimension are sorted alphabetically. Instead, I would like the pivot table's dimensions to be sorted in descending order based off a specific measure.

I have tried adding the measure's expression in the "Sort by Expression" for each dimension, however this has not worked.

If you have any solutions please let me know.

Thanks

[girirajsinh]

Hi

Pivot table in QlikSense has no Y-Value sorting.

So you will need to use dual and aggr function to assign particular dimension with sortable numerical value.

Here is the details

Is it possible to sort measure in pivot table using Qlik Sense?

[#3]

Thanks Girirajsingh!

Hopefully Qlik includes this in the future. It is my understanding it was available in Qlik View.

[girirajsinh]

Hi Kanishk

Yes your understanding is right, Y-value sort is awailable in Qlikview.

Please close this thread by putting "correct answer" if you have found what you were looking for .

[#5 · Accepted solution]

I found a solution to this issue. It works most of the times I have used it, however there have been glitches so be cautious while using it.

In the pivot table, go to Sorting. For the dimension that you want sorted, select Sort by Expression. The Expression you write is:

RANK(The expression of the measure on which you want the dimension values to be sorted).