topic is automatic qvd generation possible ???? in QlikView

is automatic qvd generation possible ????

Mon, 31 Jan 2011 08:32:34 GMT

Is there any way so that a new QVD can be generated on daily basis with new name.

This has to be done from same data source.

It possible manually but is there any way so that it may be done automatically on daily basis.

is automatic qvd generation possible ????

tresB — Mon, 31 Jan 2011 08:39:15 GMT

I did not try it , but you may try this way: get the QVD generation application scheduled daily. Now use a variable to get dynamic value like current date (using Today() function) or whatever you want to put as a part of QVD. then use this variable as a part of QVD name in your STORE command.

Regards, tresesco

is automatic qvd generation possible ????

Mon, 31 Jan 2011 08:55:57 GMT

Hi Tresesco,

Thankx for the quick response but its not working at my end , i hope some problem in script.

can you please help me out by writing the script what i have to use for the same.

is automatic qvd generation possible ????

jonathandienst — Mon, 31 Jan 2011 08:56:16 GMT

Ashwin

I suggest that you try something like the following:

Let vDailySaveName = 'DailySave' & Date(Today(), 'YYYYMMDD') & '.qvd';
Store DataTable INTO [$(vDailySaveName)];

Hope that helps

Jonathan

is automatic qvd generation possible ????

tresB — Mon, 31 Jan 2011 09:04:48 GMT

Try:.....

Let VDate=Date(Today(),'DD-MM-YY');

Store FinalTable Into '$(VDate).qvd' (Qvd);

is automatic qvd generation possible ????

Mon, 31 Jan 2011 09:17:24 GMT

Thanks to both of you , I hope this will work !!!!

is automatic qvd generation possible ????

suniljain — Mon, 31 Jan 2011 09:34:14 GMT

Dear Ashwin,

You can generate QVD automatically with the help of macros.

Regards

Sunil