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

Announcements
Join us in Bucharest on Sept 18th 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