Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ranking Data in Tables

Hi everybody,

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.

Thanx.

Rodrigo

1 Solution

Accepted Solutions
Not applicable
Author

Hi Rodirigo,

You could do this with the help of HRank(). You Expression would be as follows.

Hrank(sum(Data),0,1)

Check the attached application.

- Sridhar

View solution in original post

2 Replies
Not applicable
Author

Hi Rodirigo,

You could do this with the help of HRank(). You Expression would be as follows.

Hrank(sum(Data),0,1)

Check the attached application.

- Sridhar

Not applicable
Author

Thank you very much Sridhar, worked perfectly!

See ya...