"Load more" feature Qlikview table

[#1]

Hi everyone!

I am having a hard time with a huge table with data in Qlikview. I have a table with more than 500 thousand rows and I was wondering if there is a way to limit the load of this table in the application. Something like put a "Load more" after a X number rows so the user choose to load more rows or not. I need something like this in order to make the increase the performance of the application.

Any ideas?

Thanks!!

[oknotsen]

Not exactly what you ask, but something to consider:

Add a calculation condition that simple refuses to load the table unless there are less then X (distinct) values in field Y. By editing the error message you can even tell your user what he is expected to do in order to make the chart show data.

This solves your performance issues plus nobody can ever handle so many rows to begin with.

Now a common reply is "but I need all these rows", usually because they want to export it to Excel and build some charts or something based on that info. This is a nice moment for you to discover they apparently are missing those charts in QlikView.

[Anonymous]

Well, I dont think that we can give flexibility to User whether they want to load more data or not...

Instead of that, you can try like:

1) Reduce the data while loading(only load 1-2 year data instead of full data)

2) If you are loading full data again and again then implement Increment Load

see the following:

Incremental Load in QlikView – Part1 | Learn QlikView

Incremental Load in QlikView – Part2 | Learn QlikView

Hope this will help!!

[buzzy996]

try tis way,

create a button on ur front end application with logic by clicking on button u need to increase 20% records (x number of records).

hope helps.

[Mark_Little]

Hi,

Is this a front end table?

If so you can added a calculation condition. Like the below

=IF(COUNT('Field') < 10000, 1, 0)

then add an error message for the calculation condition unfulfilled

Mark

[ramoncova06]

you could use a slider for this

Top N Rows using Slider

let me know if you need more details