Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
dhavalvyas
Contributor III
Contributor III

Incremental not working

Hi,

I load data yesterday fron database and stored it in qvd.After check all the policynumbers for it till yesterday.

After that  apply incremental load on it by using

Trunc(sysdate)-1

CONCATENATE

YESTERDAY QVD

But after incremental load count is showing wrong ? There is difference between previous qvd count(OLD DATA IN QVD) and after increment count(SAME OLD DATA IN QVD) ?

2 Replies
mdmukramali
Specialist III
Specialist III

Hi,

Can you share the script here.

agigliotti
Partner - Champion
Partner - Champion

Which criteria did you use to apply incremental LOAD ?

What's your table primary key ?