Pivot sort by expression for specific row item on a dimension

[G-QVW]

Hi all,

Am very new to QlikView and enjoying it immensely so far but am having trouble achieving what I need for a specific requirement.

I have a pivot table that i wish to sort by ascending value of an expression for a specific row item within a dimension.

The pivot table looks like this:

The requirement is to be able to sort the entire pivot by CCY in Descending order for Entity 'Group ZZA' :

Looking specifically at Group ZZA we see PHP is the lowest currency, then LVL, SKK, MUR etc...we need this sort to apply to all Entities.

Is there a way of achieving this? I thought i could do it with a sort expression and if match eg: =if(Match([Entity],'Group ZZA'),sum(Position),0) but this doesn't seem to work.

Any help greatly appreciated.

Have included an xlsx of the dummy data and the QVW file if that helps.

Thanks,

[sunny_talwar · Accepted solution]

Try this as your sort expression

Sum(TOTAL <CCY> {<Entity = {'Group ZZA'}>}Position)

[G-QVW]

Thanks so much!