Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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

View solution in original post

Not applicable
Author

Thank you very much Sridhar, worked perfectly!

See ya...