Sort Order in Pivot as Cross table

[Lakshmanan]

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

];

[Chanty4u]

Try this 

Aggr(Sum(Value), Name, Category)

[Lakshmanan]

No didnt work , still the same , not sorted for each name

[marcus_sommer · Accepted solution]

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.

[Lakshmanan]

Thank you it worked.