Sort pivot table measure

[micheledenardi]

how to sort the measure "Worked Days" from the greatest to lowest into a pivot table on qliksense?

[Anonymous]

Hi,

Go to the properties, click on request number dimension, then click sorting. Sort by expression Sum([Worked Days]) then you can choose ascending or descending.

[micheledenardi]

This not work with pivot table....

[Anonymous]

Chart properties>Sorting>Request Number>Click back the Sorting "Auto" so it comes up as "Custom" Then tick the box that says "Sort by expression" in the box type Sum([Worked Days]) then choose descending.

[micheledenardi]

It's not as easy on pivot table... your solution works only with charts or straight table.

[Anonymous]

With the data you provided, this method works.

Maybe the data you provided is different than the actual one you are using?

[micheledenardi]

Please try to do it with the attached app. For me doesn't work.

[micheledenardi]

Any idea on how to achieve it ?

[prma7799]

I think it is already sorted till month due to request number it is getting challenge.

[micheledenardi]

Month or request number sorting are not important... the only sort i need is by Worked Days