Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Regards,
KK
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.
Hi,
We have converted into straight table no longer needed to sort in piot due to its limitation in Qlik.
Regards,
KK
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!