topic Re: Loading into multiple QVD files based on time in QlikView

Loading into multiple QVD files based on time

Tue, 30 Jul 2013 14:57:46 GMT

Hi,

i am dealing with around 400000 rows of data per day. I is stored as SQL tables in the server. And i want to store the data in qvd files.

Is there any way i can use the Reload function to put these data into different qvd files each one for a particular day.

I want qlikview to automatically load the particular data into the respective file, using something like incremental load to take the data only for that particular day.

For example

file_30_7_2013.qvd

file_31_7_2013.qvd and so on.....

Re: Loading into multiple QVD files based on time

Gysbert_Wassenaar — Tue, 30 Jul 2013 16:09:49 GMT

Something like this:

LET vDate = date(today(), 'DD/MM/YYYY')

// adjust the date format to what your sql database expects

LET vFilename = 'file' & date(today(),'D_M_YYYY') & '.qvd'

TableTodaysData:

SQL SELECT * FROM sometable

WHERE MyDateField = '$(vDate)';

STORE TableTodaysData into $(vFilename);

Re: Loading into multiple QVD files based on time

Tue, 30 Jul 2013 16:26:19 GMT

Thanks a lot,

i also have one more problem.

I have this mysql sheet that contains some historical data.

One of its fields is 'cdate'

I want to store this entire data into qvd files in a datewise manner.

is there any way in which the variable can refer to the 'cdate' and create qvd files accordingly??