Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Partially reloading data

Dear all,

I'm loading data from a database like this (actually more columns, but this is for example purposes):

ODBC CONNECT32 TO [DWH_P3.world;DBQ=DWH_P3] (XUserId is ceMTEIBHWBMOTcAHbCTCEBdLTKREFLFJDKRGVOBX, XPassword is dHUEEYVMQbcSWYIGTRRA);
LOAD "DDA_KEY_TSK":

SQL SELECT *
FROM "LAB_SERVICES"."FBI_RAPPORTAGE_FO_VERZOEKEN";

This all works fine but I loading takes quite a lot of time. Could anybody elaborate on how I can only reload the new data when I refresh?

3 Replies
MVP
MVP

Re: Partially reloading data

May be using :Incremental Load

jason_michaelid
Honored Contributor II

Re: Partially reloading data

There are lots of posts in here - search for "Incremental Load". The F1 Help is also pretty good for this. Are you familiar with the concept of Incremental Loads?

Re: Partially reloading data

Hi,

Have a look at attached document in below post.

Incremental Load Scenarios.pdf

Incremental Load in Qlikview - Sources

Regards

ASHFAQ

Community Browser