Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

incremental data

Hi All

I created a qvd with my data. then i concatenated the qvd with daily incremented data.

it is working fine.  but if i modified my actual data that was not changed in my qvd instated of that i am getting more records on that id.

i know i wrote code for insert condition only.  please help me how to write code for insert update and delete perspective.

idyearsales
15/3/20144000
26/3/20145000
37/3/20146000
48/3/20147000
59/3/20148000
65/3/20149000
71/3/201410000
86/3/201411000
96/7/201412000
104/2/201210000
3 Replies
Not applicable
Author

Insert and Update.PNG.png

Insert update and delete

Insert Update and Delete.PNG.png

swuehl
MVP
MVP

Go to http://robwunderlich.com/download and download the QV cook book.

There is well documented example of different kind of incremental loads incl. update contained.

TigerisBack
Champion
Champion

you need to store back after concatenating then only will reflect in qvd

or

see the attached file

hope this helps