Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limit number of displayed rows in a table?

Is there a way to limit the number of rows loaded/displayed in a table?  Right now I have a massive table that I would like to neck down to 1000 rows instead of the full 1.5m rows that it's trying to load by default.  Thanks!

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

not with a table box.  best you can do is set a calculation condition or show/hide condition on the layout tab on whether to show or not depending if the user has > 1000 rows in their selection.

If you have a unique identifier for the row.   it would be an expression like this   getpossiblecount( [UniqueIdentifier]) <= 1000

View solution in original post

9 Replies
nagaiank
Specialist III
Specialist III

For limiting number of rows at load time, you may use the First keyword

ModelTable:

First 1000

Load * From ... [your data table];

Not applicable
Author

Ah, I think I need to clarify - I mean limit the number of rows displayed in a table object, not a data table generated in my load script.

nagaiank
Specialist III
Specialist III

You may use Dimension Limits tab of the Table properties window for limiting number of rows displayed.

Not applicable
Author

Hi,

Have a look at the attached link.

Paging Implementation for Straight table

Hope it helps!!

Kiru

Not applicable
Author

But not for a table box, it appears?

JonnyPoole
Employee
Employee

not with a table box.  best you can do is set a calculation condition or show/hide condition on the layout tab on whether to show or not depending if the user has > 1000 rows in their selection.

If you have a unique identifier for the row.   it would be an expression like this   getpossiblecount( [UniqueIdentifier]) <= 1000

View solution in original post

Not applicable
Author

In the chart Properties --> Presentation tab , there is a checkbox Max Number(1-100). It denotes maximum no. of rows to be displayed.

Is that what you've been looking for ?

Not applicable
Author

Ah darn.  Alright.  Thanks for the information Jonathan!

Not applicable
Author

Yes, but it looks like that's not an option with a Table box