topic Re: Incremental load in QlikView

Incremental load

Mon, 26 Jan 2026 18:19:17 GMT

hi ,

Is there a way to do an incremental update of the data (only reload new data)

without loading the entire data of the db.

crusader_ — Thu, 03 Apr 2014 07:05:27 GMT

Hi Faryal,

You can try to use Partial Reload.

P.S. Be carefull with QUALIFY statement in script.

Hope it helps.

Andrei

alexandros17 — Thu, 03 Apr 2014 07:08:17 GMT

The easiest way is to use where condition, something like:

Load

where mydate > datelimit

so all new items will be loaded (I've done the example with a date, the most common situation)

Hope it helps

arsal_90 — Thu, 03 Apr 2014 07:09:10 GMT

Hi Faryal

Attached files may help you and if you still have any problem then let me know

Thu, 03 Apr 2014 07:17:26 GMT

i don't understand partial RELOAD how it's work

crusader_ — Thu, 03 Apr 2014 07:30:09 GMT

In script you add "ADD" before LOAD statement.

And you should use Ctrl+Shift+R instead of Ctrl+R - to reload script.

When "compiler" see ADD or REPLACE word before LOAD it checks for changes in loaded table and add (or replace) only new (or changed) data.

Thu, 03 Apr 2014 07:46:14 GMT

Hi Faryal,

You can make a new DBfile like QVD by using just 'Reload'

and dont need a entire data.

you just add 'plus content' on previous file.

I used concatenate.