topic Re: Selective QVD load in QlikView

Selective QVD load

Tue, 20 Oct 2015 09:11:10 GMT

Hi,

I have a problem where data is stored into multiple qvd files (broken down in either daily/montly/yearly).

I wish to have a model where the qvd file can be selected and then only loaded into memory for further investigation from a model.

How can I do this?

Re: Selective QVD load

Gabriel — Tue, 20 Oct 2015 09:50:53 GMT

Hi,

I don't think I completely understand your requirement but I think the idea below might start off suggestions.

//Define variables to use later in the script

LET vQVDPath				= '..\..\QVD Files Folder\';
LET vQVDFileToLoad		=0;

IF vQVDFileToLoad	= 0		THEN
LET vQVDFileToLoad	= 'Daily';

ELSEIF vQVDFileToLoad = 1	THEN
LET vQVDFileToLoad	= 'Monthly';

ELSEIF vQVDFileToLoad = 2	THEN
LET vQVDFileToLoad	= 'Yearly';

ENDIF

//Here is the table to Load into memory

Fact:

LOAD

Field1

, Field2

, Field3

, Field4

FROM [$(vQVDPath)$(vQVDFileToLoad).qvd](qvd);

//Clean Up variable

LET vQVDFileToLoad =;

Re: Selective QVD load

Tue, 20 Oct 2015 10:18:49 GMT

Hi,

The idea is to list the QVD files available in a model and then from the list select (like a date range) the dates to load. After the selection the in the model the QVD's selected will be loaded. i.e the folder contains:

QVD201510.qvd

QVD201509.qvd

QVD201508.qvd

QVD201507.qvd

QVD201506.qvd

...

So in the list I want to select month 8 and 9 and click load. This then will load the appropriate QVD's.

Re: Selective QVD load

Gabriel — Tue, 20 Oct 2015 10:27:28 GMT

Hi,

So listing of the QVD files to load is it done in the UI or script?

Re: Selective QVD load

Tue, 20 Oct 2015 10:29:25 GMT

The listing has not been done yet but I assume it will be done in a script and displayed in the UI. Unless there is another way of doing it.