topic Storing a QVD in dynamic name in QlikView

Storing a QVD in dynamic name

Mon, 03 May 2010 11:55:17 GMT

Hi i want to store a qvd in dynamic name and i tried as follows

Store tab into day(today())&.qvd

Store tab into table&day(today())&.qvd

Store tab into tab&$(day(today())&.qvd

Store tab into tab&$(var1)&.qvd where variable var1=day(today()

But nothing is working. How can i store a qvd in dynamic name. Kindly help me....

Storing a QVD in dynamic name

Miguel_Angel_Baeyens — Mon, 03 May 2010 12:59:16 GMT

Hello Dora,

Whether you are in a loop while creating the file name or not, I'd as follows:

LET vToday = Today();STORE TableName INTO $(vToday).QVD

This should work.

Regards.

Storing a QVD in dynamic name

Mon, 03 May 2010 13:43:04 GMT

I do something like this:

Let vFromDate=num(MonthStart(addmonths(now(), -13)));
Let vToDate = num(floor(now(),1)) - 4;

do while vFromDate < vToDate
// logic
Let QVDFileName = '..\qvd\Data' & '-' & date(vFromDate, 'YYYY-MMM-D') & '.qvd';
store Data into $(QVDFileName );
Drop table Data;
Let vFromDate = vFromDate + 1;
loop