Rank based on selected value

[Anonymous]

Hi

I am trying to create a rank straight table with different users and their usage. But if a user selects a specific User than it will display 5 Users above and 5 below. Similar to the ranking on the QlikView community page for individual leaders, with an option to view either top 10 or my rank. I got the top 10 table but i am not sure how to show my rank compared to everyone else.

Thanks!

[swuehl · Accepted solution]

Maybe like in attached sample QVW (it's all in the expressions of Freight table chart).

[Anonymous]

Thanks!

I added a little to the code to allow it to show top 10 when you select any of the top 5 or no selections. Is this correct, or is there a simpler way of doing this?