Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with several columns (such as customer name, address, item, etc.). The table is sorted by sales amount from highest to lowest. I want to limit the number of rows displayed to only first 10 rows.
I did not find anywhere in the table preferences any option that allows the above restriction to be implemented.
How can I solve this request ?
Thanks.
This is good.
It applies the Dim7 flag filter when creating the classification
sum({<Dim6 = {"=rank(sum({<Dim7={1}>}Value), 4)<= 10"}>} Value)
@Selis
See this in the properties of your dimension?
Or, if applicable, also by measure expression:
sum({<customer = {"=rank(sum(sales), 4)<= 10"}>} sales)
- Regards, Matheus
Hi Matheus,
I'm using a Table Chart and this option you've mentioned doesn't exist in the Table properties.
In dimension? changed the Limitation option to "Fixed Number"?
Hi Matheus,
I'm using Qlik Sense Cloud, and the above "Limitation" (presented in your screen shot) doesn't exists in the Table chart properties.
I've tried using the "Rank" command, but since I'm using several columns in My table - It "ignores" the sort I'm using in the table (meaning It displays 10 rows but ignores the sorting of the values).
Strange that you report not having this property, to better help provide an example of your table, and the output you want.
- Health
This is the example of the table I'm using. I only want to display the Top 10 lines which are sorted by the column "Opp sum" (The table is right to left and U can ignore the Hebrew words).
Tell me if I'm missing something?
Hi Matheus,
Thanks ! This one works.
what if I've another field in table (such as Dim7) which can have the values of '1' or '0' and I want the above solution to include only the rows which the value of Dim7 = '1' ?
This is good.
It applies the Dim7 flag filter when creating the classification
sum({<Dim6 = {"=rank(sum({<Dim7={1}>}Value), 4)<= 10"}>} Value)