Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Try this as your sort expression
Sum(TOTAL <CCY> {<Entity = {'Group ZZA'}>}Position)
Try this as your sort expression
Sum(TOTAL <CCY> {<Entity = {'Group ZZA'}>}Position)
Thanks so much!