topic Re: Rank by second dimension ignoring first dimension in pivot in QlikView

Rank by second dimension ignoring first dimension in pivot

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

I wanted to rank the expression by second dimension ignoring first dimension. how can i do? can you help?

Attached sample.

Thanks,

Re: Rank by second dimension ignoring first dimension in pivot

salted — Wed, 17 Jul 2019 12:29:29 GMT

Hey,

why don't you try using

AGGR(Rank([what you want to rank]),[what you want to rank by])

Re: Rank by second dimension ignoring first dimension in pivot

Brett_Bleess — Mon, 12 Aug 2019 15:11:52 GMT

Did Parth's comment help, or are you still trying to figure something out? If it did, be sure to click the Accept as Solution button the post to give credit. If not, further details will likely help someone try to help further. I see you posted an app, that should be very helpful, but may need a bit more detail on things, only reason of which I can think others have not posted on this one.

Regards,
Brett