Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have tried multiple options to sort the pivot -cross table in qlikview for the "Total" in descending order for each Name, but didnt work . If anyone has resolved this , kindly share the solution
sample :
load * inline [
Name,Category, TagName , Value
ABC, Bird ,XYZ,300
ABC,Animal,YYY, 200
CDE,Bird,ZZZ, 100
CDE,Pet,YYY,300
ABC,NonPet,XYZ,150
];
Sorting within a pivot is difficult to impossible - at least with the normal approaches. In many cases you will need a workaround - quite common is here to use a calculated dimension which contained beside the visible dimension-values also an appropriate numeric value, for example for the dimension Category with something like:
dual(Category, Aggr(Sum(Value), Name, Category)))
and then sorting this field within the properties numerically.
Try this
Aggr(Sum(Value), Name, Category)
No didnt work , still the same , not sorted for each name
Sorting within a pivot is difficult to impossible - at least with the normal approaches. In many cases you will need a workaround - quite common is here to use a calculated dimension which contained beside the visible dimension-values also an appropriate numeric value, for example for the dimension Category with something like:
dual(Category, Aggr(Sum(Value), Name, Category)))
and then sorting this field within the properties numerically.
Thank you it worked.