topic Pivot table - Unable to sort multiple measures in QlikSense in App Development

Pivot table - Unable to sort multiple measures in QlikSense

Karim_Khan — Thu, 19 Jun 2025 07:23:42 GMT

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,

Re: Pivot table - Unable to sort multiple measures in QlikSense

rubenmarin — Sat, 21 Jun 2025 07:21:33 GMT

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.

Re: Pivot table - Unable to sort multiple measures in QlikSense

Karim_Khan — Mon, 07 Jul 2025 13:52:22 GMT

Hi,

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

Regards,

Re: Pivot table - Unable to sort multiple measures in QlikSense

mattewwade06 — Wed, 23 Jul 2025 08:00:05 GMT

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!

company let

Re: Pivot table - Unable to sort multiple measures in QlikSense

carlbidwell — Tue, 14 Apr 2026 11:59:25 GMT

This is a common limitation in Qlik Sense pivot tables where multiple measures can’t be directly sorted together in descending order. A practical workaround is to create a single sorting expression or master measure and then use “Sort by expression” based on that field, which helps control the overall order. In some cases, restructuring the data model (unpivoting measures into a single field in the load script) can also give better sorting flexibility.