Pivot sort by expression for specific row item on a dimension

G-QVW — Wed, 05 Jun 2019 10:37:05 GMT

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,

Re: Pivot sort by expression for specific row item on a dimension

sunny_talwar — Wed, 05 Jun 2019 12:46:55 GMT

Try this as your sort expression

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

Re: Pivot sort by expression for specific row item on a dimension

G-QVW — Wed, 05 Jun 2019 16:09:04 GMT

Thanks so much!

topic Re: Pivot sort by expression for specific row item on a dimension in QlikView

Pivot sort by expression for specific row item on a dimension

Re: Pivot sort by expression for specific row item on a dimension

Re: Pivot sort by expression for specific row item on a dimension