Sorting in pivot tables (using calculated expression?)
I made a pivot table calculating some percentages and absolute values. However, I want the table to sort based on the total of the absolute values. So now I have: see screenshot 1
and what I want is that Netherlands is on top, then Belgium, then Germany and lastly France because the total absolute value is the following:
I tried using the following as calculated dimension:
But this does not give me the result I want.
field = the field I use for the absolute value.
I use the 4 countries as a filter so I have them selected, I can also ask it to calculate those totals because the columns are pivotted using another field so just removing this field from the dimensions gives me the totals. So how to get Qlikview to sort using these values?
Re: Sorting in pivot tables (using calculated expression?)
This works but (and now I am gonna be very annoying) it does calculate it based on the full data. I restarted and made the table now with set expressions where I can change the data using a variable and it will be completely independent from the current selection. Is there a way you can add a set expression in there so that I can say I want to filter using <land> but also field = variable where field is the date field and variable is the month I want the variable to be?