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.