Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

micheledenardi
Valued Contributor

Sort pivot table measure

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

2017-11-08 16_19_21-KS IT Activities(Sviluppo) - Worked Request By Resource _ Fogli - Qlik Sense.png

14 Replies
michaelblackbur
New Contributor III

Re: Sort pivot table measure

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
Valued Contributor

Re: Sort pivot table measure

This not work with pivot table....

michaelblackbur
New Contributor III

Re: Sort pivot table measure

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
Valued Contributor

Re: Sort pivot table measure

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

2017-11-08 17_17_13-KS IT Activities(Sviluppo) - Worked Request By Resource _ Fogli - Qlik Sense.png

michaelblackbur
New Contributor III

Re: Sort pivot table measure

With the data you provided, this method works.

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

ss3.PNG

micheledenardi
Valued Contributor

Re: Sort pivot table measure

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

micheledenardi
Valued Contributor

Re: Sort pivot table measure

Any idea on how to achieve it ?

prma7799
Honored Contributor III

Re: Sort pivot table measure

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

micheledenardi
Valued Contributor

Re: Sort pivot table measure

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

Community Browser