Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.
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!!
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.
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