Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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 ?