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.
your script looks ok. Only change you need is below
AutoNumber(Sale,Product) as Rank
View solution in original post
You can try this at front end, I don't have licensed version so cannot view qvw, below image can help, Product/SubProduct are chosen as dimension in straight table -
Thanks Kush working fine..Thanks Sam and Digvijay Too.
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
Great solution. Took a little while to find this, so a 'like' might help future searchers.
Nice work & website too.