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: 
Aarya_Kankipati
Contributor III
Contributor III

How to specify top 10 for a dimension


I have a table and Product is my dimension; How can I specify to show only TOP 10 Products

({<STATUS_CODE ={'ABC','DEF'},LOCATION_COUNTRY_CODE = {'US','CA'}>}[PRODUCT])

Labels (6)
1 Solution

Accepted Solutions
aruneshgupta
Creator
Creator

It looks you have old version.. if you are showing top 10 based on your measure then use rank in measure.  below example: 

Sum({<Customer = {"=Rank(Sum(Sales))<=10"}>} Sales)

Regards,

Arunesh

View solution in original post

3 Replies
Or
MVP
MVP

This should be available as one of the options under the dimension properties.

Or_0-1701875008517.png

 

Aarya_Kankipati
Contributor III
Contributor III
Author

The problem is : Its not showing that

Aarya_Kankipati_0-1701875212710.png

 

aruneshgupta
Creator
Creator

It looks you have old version.. if you are showing top 10 based on your measure then use rank in measure.  below example: 

Sum({<Customer = {"=Rank(Sum(Sales))<=10"}>} Sales)

Regards,

Arunesh