Discussion Board for collaboration related to QlikView App Development.
I want to give a rank according to Sales but not on overall but within a groups. for e.g. I want a rank within a group for sales in Traditional, Ulip and Saving.
I have tried with a below given logic but by this logic I am getting a rank overall where as my requirement is within a Group..
(ooxml, embedded labels, table is Sheet1);
AutoNumber(Sale) as Rank
Resident A Order by Sale desc;
DROP Table A;
Thanks in advance.
This approach gives the correct results, but is incredibly slow for anything but the smallest data volume. I wrote this up here: https://www.michaelsteedle.com/2019/04/ranking-within-group-quickly-in-qlik.html
TL;DR This is >99% faster:
If(Product = Previous(Product), Peek(Rank) + 1, 1) as Rank