how to sort the measure "Worked Days" from the greatest to lowest into a pivot table on qliksense?
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.
This not work with pivot table....
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.
It's not as easy on pivot table... your solution works only with charts or straight table.
With the data you provided, this method works.
Maybe the data you provided is different than the actual one you are using?
Please try to do it with the attached app. For me doesn't work.
Any idea on how to achieve it ?
I think it is already sorted till month due to request number it is getting challenge.
Month or request number sorting are not important... the only sort i need is by Worked Days
Please check this ..
It is sorted...
no, Worked Days it's not sorted at request number level.. thanks for the help
I think it is not taking 3 level of sorting ...
This is exctly what i suspect...
That's I told you due to request number it is not giving proper sorting.
Retrieving data ...