Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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