Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rank based on selected value

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!

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

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

View solution in original post

2 Replies
swuehl
Champion III
Champion III

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

Anonymous
Not applicable
Author

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?