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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Donthamsetty10
Contributor II
Contributor II

Display top 10 ranks

I have tried this expression but it's not displaying top 10,

=Aggr(If(rank(Sum(Sales))<=10, State), State)

Its displaying state names instead of rank.

Screenshot 2022-10-26 at 11.36.51 AM.png

Labels (2)
2 Replies
Mark_Little
Luminary
Luminary

Hi, 

Why don't you just use the inbuilt limitation options in the dimension?

 

Donthamsetty10
Contributor II
Contributor II
Author

Inbuilt function was showing for other tables, but it wasn't showing for this table. How come so ?