Hi Guys... I have a qvd load which should be triggered only after database load completes. Currently I have set it up based on time but still there are some instances where database load is delayed and we have to run qvd load again to refresh the data. is there any way this dependency can be set in qview script?
When you talk about a "database load", are you talking about some batch job running in your business system, outside of QlikView? If so, the way we handle this in our shop is to have the business system send a message (EDX?) to QlikView to initiate the QVD reload once the database load is complete. I'm not entirely clear on the details, though. I know that in Publisher, the trigger is "Start the task On an external event".
Biggest problem would we to find out, when the database has finished reload - had overlooked this in my first reply. Wonder whether it is possible in the maindatabase to add one field "Last Refreshed" or the like, which might be questioned before loading the main-table into Qlik.