How to create multiple qvd's

[sushil353]

Hi ALL,

• We have two application one is dataloading.qvw and other is dashboard.qvw. The first application is used to create the qlikview data file i.e data.qvd file and second application used those qvd file as a data source to run the dashboards..

• The  Problem is

• The table from which data is loaded to data.qvd file is very large in size. so we are planning to create  separeate qvd file for each day, means for every day when the application run by schedular, it should create a separate qvd file for the previous day (with a time stamp). so that the dashboard.qvw application takes data from multiple qvd files.. How this task is possible??

• The whole task should be automated..means by scheduling the task...

Can Anybody please help to solve this puzzle....

Thanks..

[sushil353]

Help me guys

[kaushiknsolanki]

Hi,

   You mean to say daily you want to create a qvd file for that day only.

   Then you can do like this.

   Load Filed1, Filed2

   From xyz where date =  date(today(),'DD/MM/YYYY')

   For previous day use like this.

   Load Filed1, Filed2

   From xyz where date =  date(today()-1,'DD/MM/YYYY')

Regards,

Kaushik Solanki

[sushil353 · Accepted solution]

yes but for every day qvd file should be new, with date stamp...and previous qvd should not be deleted...

so that day after tommorw i have 2 avd file or say 2 previous day data

[montubhardwaj]

T1:

Load F1,

F2,

F3,

Date

;

Select F1,

F2,

F3

From abc

where Date=<today's date>               /*  make sure the date format is same as from Database*/

;

Let qvd_date=Peek('Date',0,T1)   /* to create a variable so that you can differentiate between the qvds*/

Store * from T1 into $(qvd_date).qvd;

Hope this will help you.