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.
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.
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.
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.