topic Re: Restrict number of displayed rows in a table in Qlik Answers

Restrict number of displayed rows in a table

Selis — Thu, 06 Feb 2025 12:54:10 GMT

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.

Re: Restrict number of displayed rows in a table

MatheusC — Thu, 06 Feb 2025 13:33:20 GMT

@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

Re: Restrict number of displayed rows in a table

Selis — Thu, 06 Feb 2025 13:34:53 GMT

Hi Matheus,

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

Re: Restrict number of displayed rows in a table

MatheusC — Thu, 06 Feb 2025 13:39:55 GMT

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

Re: Restrict number of displayed rows in a table

Selis — Thu, 06 Feb 2025 14:02:20 GMT

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

Re: Restrict number of displayed rows in a table

MatheusC — Thu, 06 Feb 2025 14:49:36 GMT

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

- Health

Re: Restrict number of displayed rows in a table

Selis — Thu, 06 Feb 2025 15:00:53 GMT

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

Re: Restrict number of displayed rows in a table

MatheusC — Thu, 06 Feb 2025 19:01:29 GMT

Tell me if I'm missing something?

Re: Restrict number of displayed rows in a table

Selis — Fri, 07 Feb 2025 09:14:05 GMT

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

Re: Restrict number of displayed rows in a table

MatheusC — Fri, 07 Feb 2025 12:55:48 GMT

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

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

Re: Restrict number of displayed rows in a table

Selis — Fri, 07 Feb 2025 14:25:04 GMT

Perfect ! it works fine.

Thanks for your kind support !