Table visualization - display top 10 rows only - Qlik Community

jerryr125 · ‎2022-02-07

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 · ‎2022-02-07

If possible try to use rank function inside the measure.

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

anat · ‎2022-02-08

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