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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Selis
Contributor III
Contributor III

Restrict number of displayed rows in a table

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.

Labels (1)
2 Solutions

Accepted Solutions
MatheusC
Specialist II
Specialist II

This is good.
It applies the Dim7 flag filter when creating the classification

MatheusC_0-1738932901081.png


sum({<Dim6 = {"=rank(sum({<Dim7={1}>}Value), 4)<= 10"}>} Value)

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

Selis
Contributor III
Contributor III
Author

Perfect ! it works fine.

Thanks for your kind support !

View solution in original post

10 Replies
MatheusC
Specialist II
Specialist II

@Selis 
See this in the properties of your dimension?

MatheusC_0-1738848291511.png

Or, if applicable, also by measure expression:

sum({<customer = {"=rank(sum(sales), 4)<= 10"}>} sales)

- Regards, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Selis
Contributor III
Contributor III
Author

Hi Matheus,

I'm using a Table Chart and this option you've mentioned doesn't exist in the Table properties.

MatheusC
Specialist II
Specialist II

In dimension? changed the Limitation option to "Fixed Number"?

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Selis
Contributor III
Contributor III
Author

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).

MatheusC
Specialist II
Specialist II

Strange that you report not having this property, to better help provide an example of your table, and the output you want.

- Health

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Selis
Contributor III
Contributor III
Author

Selis_0-1738853946242.png

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).

MatheusC
Specialist II
Specialist II

Tell me if I'm missing something?

MatheusC_0-1738868448973.png

 

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Selis
Contributor III
Contributor III
Author

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' ?

 

 

MatheusC
Specialist II
Specialist II

This is good.
It applies the Dim7 flag filter when creating the classification

MatheusC_0-1738932901081.png


sum({<Dim6 = {"=rank(sum({<Dim7={1}>}Value), 4)<= 10"}>} Value)

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!