Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Limit the number of rows initially displayed in a straight table

Is there a way to limit the number of rows initially displayed in a chart object? Currently, I have a straight table that loads thousands and thousands of records and is taking up time and memory. Is it possible to display the first 100 records and have a way for users to navigate to the next 100 and so forth?

I realize that the dimension limit can be set to restrict the number of values displayed, but this does not allow users to ever see the complete record set. Often times, users want to be able to export all records to Excel for further manipulation and not just the first 100.


Any help would be greatly appreciated. Thanks in advance!

9 Replies
Highlighted
Master II
Master II

Re: Limit the number of rows initially displayed in a straight table

Hi.

You can predefine selection of the first 100 rows by default and then the user can change it.

If export to Excel is the only reason you can use minimized/hidden object that should not consume much memory until is used.

Highlighted
Specialist II
Specialist II

Re: Limit the number of rows initially displayed in a straight table

You can use dimension limits, just set the value for the first # of rows to be a variable like vLimit. Then use either an input box or maybe a textbox to toggle between 100 and all records.

PFA

Hope this helps!

Not applicable

Re: Limit the number of rows initially displayed in a straight table

Hey Lily,

You can assign a variable to display n rows of data. You can default it to 100. Create an input box and whenever the user changes the value to say 300 that many rows will be displayed.

Another technique which is commonly used is not to show anything at all until certain specific selections are made (Calculation Condition). It has a huge impact on performance.

Because looking at the entire data may not be productive, so make them narrow down the selections based on business inputs on how they would use the chart for analysis.

Hope it helps.

thanks

AJ

Highlighted
Partner
Partner

Re: Limit the number of rows initially displayed in a straight table

Please take a look at this qvw paging sample.

Michael

Highlighted
Champion III
Champion III

Re: Limit the number of rows initially displayed in a straight table

It is possible, but somewhat limited.

See attached.  There is table "Data", and next, in the script, I created field TableSortOrder.  Since it is in the script, it is predefined and can be changed in the script only.  Do not allow interactive sort either.

Page Size can be changed on the front end.  Added buttons to scroll between pages.

Highlighted
Not applicable

Re: Limit the number of rows initially displayed in a straight table

Is it possible to provide interactive sorting with paging in qlikview table box

Highlighted
Partner
Partner

Re: Limit the number of rows initially displayed in a straight table

Hi Michael. From what I can see your solution will not work properly if the user makes selections, since the row numbers is in the data, which I think is what almost everyone looks for.

Is it possible to always show a certain amount of rows, independently of the user's selections?

Highlighted
Champion III
Champion III

Re: Limit the number of rows initially displayed in a straight table

Yes - use "Max Number" in the presentation tab of the chart properties.

Highlighted
Partner
Partner

Re: Limit the number of rows initially displayed in a straight table

Dear Jeremiah,

How can we achaive the same results with Multiple Dimension. With Multiple Dimension ""DIMENSION LIMIT "" does not work.

Please advse if we can handle the row limit on straight table chart with MULTIPLE DIMENSION SAY MORE THAN 5 DIMSNION.