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

Limit the number of rows initially displayed in a straight table

Thu, 16 Jan 2014 20:42:09 GMT

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!

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

whiteline — Thu, 16 Jan 2014 20:52:18 GMT

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.

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

jerem1234 — Thu, 16 Jan 2014 20:54:54 GMT

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!

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

Thu, 16 Jan 2014 21:00:59 GMT

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

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

agilos_mla — Thu, 16 Jan 2014 21:07:07 GMT

Please take a look at this qvw paging sample.

Michael

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

Anonymous — Thu, 16 Jan 2014 21:24:12 GMT

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.

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

Fri, 21 Feb 2014 19:52:31 GMT

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

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

isorinrusu — Mon, 22 Dec 2014 17:40:44 GMT

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?

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

Anonymous — Mon, 05 Jan 2015 20:48:53 GMT

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

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

aj0031724 — Thu, 09 Mar 2017 09:08:53 GMT

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.