In my dashboard I am using the below code to incremental load Salesforce.com data. This code is taken from the demo app that is available on QlikView web site.
I am not able to understand how this code handles the Accounts that get deleted within SFDC? After running the below code for 30 days, I now have a around 100 accounts in my QVD which are not in SFDC (deleted ones). I can't shift to full load as its a huge data and refresh cycle is every 30mins.
Can any one had similar problems?
WHERE LastModifiedDate >= $(vLastExecTime) and LastModifiedDate < $(vExecTime);
// For the 1st reload, this section will be skipped.