Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Karim_Khan
Creator III
Creator III

Pivot table - Unable to sort multiple measures in QlikSense

Hi Folks,

Hope you're doing well !!

I came across one of the requiremnet where we need to show all measures value in descending order in pivot table of qliksense.

Is there a way to do customize sorting of pivot tables in Qlik sense so that measures should show in descending order, I have tried both sort by first measure and sort by expression but still lagging to get this.

Karim_Khan_0-1750317811627.png

 

Regards,

KK

KK
Labels (3)
3 Replies
rubenmarin

Hi I'm not sure to understand the question... If D-d has 410 on measure b1, and 11.2% in measure 9... You wan't to keep MEasure 1 shown on the 4th but show Measure 9 of the 2nd row?

If you want the user to select the column to sort of the pivot, I did it using a varible as sorting measure selector and creating an expression that uses that variable value to sort by expression.

Karim_Khan
Creator III
Creator III
Author

Hi,

We have converted into straight table no longer needed to sort in piot due to its limitation in Qlik.

Regards,

KK

KK
mattewwade06
Contributor II
Contributor II

Yeah, this is definitely one of those Qlik Sense limitations that can be frustrating. Unfortunately, native support for sorting multiple measures independently in pivot tables is pretty limited. Some users work around it by using calculated dimensions or moving key measures into rows instead. Hope Qlik adds more flexible sorting options in future updates!

Spoiler