Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a Straight Table containing 600.000+ lines. The effect is loading this takes a while, and the application is unresponsive in the meantime.
Is there some way to partially load this and tell Qlikview to load the entire table upon explicit request only.
For example, load the first 100 lines, then use a button to start loading the remaining 600k+. I am explicitly looking for a solution to this problem in the front end (is possible), not in the load script.
Thanks!
Hi all,
Thanks a bunch for your help and suggestions.
Eventually how I solved this case is by adding duplicate expressions, making both conditional. The first expression contains a set analysis for a certain period only. With a button users can switch to the other expressions which loads and shows data for all periods.
Henk-Jan
I don't think there is a feature like this in QV.
Maybe you can use the show / hide condition and create two charts, first chart visible from the beginning, only showing limited data, second showing all data, but hidden first and then showed after clicking a button.
This needs to be done in the load script, its not an option in the front-end.
The best approach is to use an incremental load to just load the transactions that have changed since the last load, and load the unchanged data from QVD files.
Also do you need to load all the columns? Reducing the width of the data being loaded can improve reload performance.
If loading from SQL it is better to just select the columns you require in the SQL script,rather than using "select *" to get all columns and then excluding columns on the QlikView side of the script.
You may also want to look into 'direct discovery':
Hi,
Not sure about the performance. may be if (RowNo(TOTAL)<=100, YourExpression) ?
Create a Button & Variable. -> Assign the value in Button Action.
in Expression if($(v1)=0, if (RowNo(TOTAL)<=100, YourExpression),1)
Henk, why not limit the dimension, without others, with a variable?
Like the attached?
Have a look at his blog post:
Hi,
one solution could be:
hope this helps
regards
Marco
This one I considered already. Thanks!
Thanks for your suggestion. The columns and amount of rows are a given, no flexibility there at the moment. Incremental load wouldn't help, because it takes so long to render the entire table (because of so many rows), not to load the data.