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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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?