topic How to create multiple qvd's in QlikView

How to create multiple qvd's

sushil353 — Thu, 07 Jul 2011 03:58:16 GMT

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 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??

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

Thanks..

sushil353 — Thu, 07 Jul 2011 06:25:46 GMT

Help me guys

kaushiknsolanki — Thu, 07 Jul 2011 06:29:58 GMT

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 — Thu, 07 Jul 2011 06:44:53 GMT

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 — Thu, 07 Jul 2011 06:47:27 GMT

T1:

Load F1,

F2,

F3,

Date

;

Select F1,

F2,

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.