Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with many fields and I want to sort each of these fields by absolute variance.
So I have applied through sort by expression for each of the field, (FABS(sum([Feb])-sum([Jan]))). But only the first field sort by absolute variance. The others do not.
Hope I can get some guidance on fixing the problem
Below field 1 sort correctly by top absolute variance. But the 2nd screen shows the subsequent fields are sorted incorrectly
Hi @43918084
Which version of Qlik Sense you are using. I am using April 2020 version and in that it is possible in a pivot table to define overall sorting order and sorting order at each level.
Thanks a lot. I m still using 2019 version, unfortunately.