Unlock a world of possibilities!
now and discover the exclusive benefits awaiting you.
We're building a qlikview dashboard where we're fetching data from various sources.
A requirement is that the data must be loaded from the first day of the current year.
The dashboard will be reloaded every 5 minutes by our Qlikview Server.
As time passes the amount of data will grow. Now, with every reload it will fetch the same data that was previously loaded again + the newly added records, since the reload.
How can I reduce the reload duration by only fetching new data. In stead of reloading the whole set (i.e set from 01-01-2014 in this case)?
A part of the dashboard is included as an attachment. You can see the queries from the databases, and some other transformations.
Note: This is only a part of the full document.
Read this blog post: http://www.quickintelligence.co.uk/qlikview-incremental-load/
And try reading some of the results this search returns:
And using the Qlikview Components library can make it even easier: Incremental Load using Qlikview Components | Qlikview Cookbook