We have a QlikView-appliction that is split into two parts. We have one document that only creates QVD-files from our database. These are saved to a local folder, let's say C:\QlikViewData.
The other document which contains the GUI, macros and everything else loads its data from these QVD-files. Nothing weird so far right?
Here's where it gets tricky.
I'd like to find a way to load the document with data from an alternate location, say C:\QlikViewData\alt, before then executing a specific macro and finally reloading with data from the usual location (C:\QlikViewData).
So basically a button that does:
Reload document with QVD-files stored at C:\QlikViewData\alt
Reload document with QVD-files stored at C:\QlikViewData
Has anyone here done anything like this before? Could you offer some pointers to the best way to go about doing this? I'd be grateful for any and all help I can get.
EDIT: I noticed that point 1 and 3 had incorrectly switched. It is now as it should be. Reload with alternate location first, run macro and then restore from usual location.