Discussion Board for collaboration related to QlikView App Development.
I have a question about ranking some data. I have every purchase from each client in my database, and I also have a column that tells me where (Store_ID) each customer made this purchase.
What I need is making a Ranking, by Store, that indicates wich position each customer has in each store (1st buyer, 2nd buyer, etc).
I made an example in Excel spreadsheet attached, to make it clear.
If you can help me with this issue, would be great.
You could do this with the help of HRank(). You Expression would be as follows.
Check the attached application.
View solution in original post
Thank you very much Sridhar, worked perfectly!