Typically you use QVD files to store older data and you add newer data from the database. Search Online Help for "Incremental Load", there is a nice article there, with examples and explanations.
We have a documentation around Incremental load. This particular paper is about how QlikTech uses Salesforce data, but you find the actual scripts for incremental load in there also.
There's an example of doing incremental loads in Rob Wunderlich's QlikView Cookbook. The example doesn't handle incremental deletes, if that's a requirement. To do that, I join back to the list of keys still in the database, which has the effect of deleting from the QlikView table.
Hi Shima, I'm a newbie in QlikView's technology. Could you kindly tell me how can I access to QlikOpedia - Best Practices? When I click on the link you have posted opens a message box where you must enter your username and password and there is no possibility to register.
If you do not have login, I would recommend you to download Salesforce qvw file available in demo.qlik.com. it is called "Salesforce", and in the scripts of the qvw file, you should be able to see a sample of incremental load. I hope it helps.
I went to through salesforce.qvw but I am not able to understand how they are doing the incremental load as it is happening in so many places. Requesting you to work on it in my small document which I have attached so it it is understandable for me.
Here is the documentation I was suggesting earlier. This is about 1.5 yrs old, but you should be able to get the idea of what we are trying to accomplish. I hope this helps.
John thanks for that application its really good. But what happens if you have more than one table. Should I repeat the incremental code for each table or not?
