topic Reload using QVD-files from alternate location in QlikView

Reload using QVD-files from alternate location

Mon, 14 Nov 2011 12:31:21 GMT

Hello all,

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
Run macro
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.

Message was edited by: thedanlof

Re: Reload using QVD-files from alternate location

Mon, 14 Nov 2011 15:06:32 GMT

Hi,

Seems like a sensible idea (I'm currently doing a simlar thing). One suggestion, if I'm reading this correctly, would be to use IsPartialReload()

The first part would run the script using a Full Reload macro: activedocument.reload

The script (by setting a varible to IsPartialReload: let PR= if(IsPartialReload() =0, 'N', 'Y') loads from location a if PR=N

The second part would run the script using a Partial Reload macro: activedocument.partialreload

The script then loads from location b if PR=Y

Of course the second part (partial reload) will keep the original data but that can be easily dropped

Reload using QVD-files from alternate location

erichshiino — Tue, 15 Nov 2011 13:55:27 GMT

Hi,

You can use a variable to right part of the file path.

Let us call this variable 'Path'

The steps will become:

1.1 set Path to 'C:\QlikViewData\alt\'

1.2 Reload data

2. Run Macro

3.1 set Path to 'C:\QlikViewData\'

3.2 Reload Data

The load statement in script will be like this:

Load * from

$(Path)\SALES.QVD

Hope this helps,

Erich