Table visualization - display top 10 rows only

[jerryr125]

Hi - 

I am stuck on this one. 

I have a table visualization with six columns :

Location, Major Category, Minor Category, Sub Category, Product Name, Quantity Sold

• Location, Major Category, Minor Category, Sub Category, Product Name are all dimensions
• I set the limitation to 'top 10' and turned off the 'Show Others'
• For the dimensions it states "Calculated on Measure: Quantity Sold"
• The Quantity Sold is a measure : sum(quantity sold)
• I have sorted the table by Quantity Sold

I only want to show the highest 10 (top 10) quantity

This is not working - it displays all records (and there is 1000's of records).

Any thoughts ? thanks - Jerry

[Digvijay_Singh]

If possible try to use rank function inside the measure.

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Ranki...

The dimension limit even if you set for each and every dimension, sometimes the overall combination won't give you only 10 rows.

[anat]

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