topic Re: Reloading data and missing old data in QlikView

Reloading data and missing old data

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am having data from 1 April 2016 to 7 April 2016 in the QVD file which I am pulling from DB, I am having 2 calendar controls I,e StartDate and EndDate and a button.When I click on dates 01-april-2016 to 01-april-2016 it is storing 7 days data in QVD.But when again I am selecting 05-april-2016 to 07-april-2016 I am only getting data for 2 days I,e 05 april and 06 april .I want to append the new data to the QVD file and old data should remains the same .

Appending new data to my QVD file ....

I tired partial load using button in reload options but I could find any change .

Please suggest ?

Re: Reloading data and missing old data

Chanty4u — Thu, 07 Apr 2016 16:01:23 GMT

can u share ur script?

any errors? does the new Qvd havng the data?

check seperatly.

Re: Reloading data and missing old data

qlikvfpi — Fri, 08 Apr 2016 12:59:31 GMT

for the partial reload, have you well set the add load in your script ?

Re: Reloading data and missing old data

Anonymous — Fri, 08 Apr 2016 13:06:12 GMT

Sounds like you need an Incremental Load - a web search will give you of hits for "QlikView Incremental Load".

Here is the link to a good blog post, http://www.quickintelligence.co.uk/qlikview-incremental-load/

Re: Reloading data and missing old data

Chanty4u — Fri, 08 Apr 2016 13:52:56 GMT

chk dis

Incremental Load in Qlikview - Sources