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: 
Not applicable

Rank based table object

Hi,

I have a detail table in the dashboard with the ranks field and I wanted create another table which should display only Rank 1, another table with Rank 2 another table with Rank 3 etc....up to 10 tables.

I tried using all expressions with If Rank=1 then sum() but not getting correct results.

Thanks,

6 Replies
ecolomer
Master II
Master II

Can you send more info or a file with data?

Not applicable
Author

Pls find the attached sample data which I pulled from table object, and I want show 10 other table objects with their rankings... I  marked YELLOW field.

Not applicable
Author

Have you tried putting your condition in the dimension and not the expression?

Not applicable
Author

Yep, I tried, but no effect

Not applicable
Author

Hi,

Plz find attached file

I have created sample QVW application. check your requirement is matching or not.

rank table.png

Regards,

Vivek

Not applicable
Author

Hi,

Plz find attached file

I have created sample QVW application. check your requirement is matching or not.

rank table.png

Regards,

Vivek