Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III
‎2021-06-05 04:34 PM

Rank by Dimension

Hi everyone,

I need to show top 10 ranking in dimension, but I need to show grouping "OTHERS" in bottom too. 

Top 10 is ranking by measure MAT ACT. Please your help.

top10.PNG

Labels (2)
Labels
1,303 Views
0 Likes
2 Replies
MayilVahanan
MVP
MVP
‎2021-06-05 09:14 PM

HI @Ronald 

In second dimension, you can try like below

Aggr(If(Rank($(vMetric))<=10, Laboratory, 'Others'), Laboratory)

or

try like below

MayilVahanan_0-1622942056375.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
1,275 Views
0 Likes
Ronald
Contributor III
Contributor III
‎2021-06-06 10:13 PM
Author

In response to MayilVahanan

Thanks Mayil, but "Others" repeat many times, not grouped. I need to show rank in dimension, is the first column.

rank2.PNG

 

1,250 Views
0 Likes