Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do a 'incremental' load to save time?

Hi,

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.

1 Reply
Gysbert_Wassenaar

Read this blog post: http://www.quickintelligence.co.uk/qlikview-incremental-load/

And try reading some of the results this search returns:

http://community.qlik.com/search.jspa?q=incremental+load

And using the Qlikview Components library can make it even easier: Incremental Load using Qlikview Components | Qlikview Cookbook


talk is cheap, supply exceeds demand