Dynamically creating a qvd file name.

wgonzalez — Tue, 18 Sep 2012 19:22:47 GMT

Hi,

I want to dynamically create a qvd file name in the script, i.e. I want the qvd file name to be different each time it is created.

I'm using these script instructions that are not working, but I think I'm near to find the solution. Could any one provide ideas?

// Save all employees to QVD file.
// Saves headcount for the particular month.

SET vTableName = 'viewEmployee';

LET vMonthDay = Month(Today())&day(Today());
LET vFilename = $(vTableName)&$(vMonthDay);
$(vTableName):
LOAD id,
today() as EffectiveDate,
month(today());
SQL SELECT *
FROM "mydatabase".dbo.viewEmployee;

store * from $(vTableName) into $(vRoot)Extracts\$(vFilename).qvd;
drop table $(vTableName);

Re: Dynamically creating a qvd file name.

MayilVahanan — Tue, 18 Sep 2012 19:40:48 GMT

Use Now() instead of

Month(Today())&day(Today())

Hope it helps

topic Re: Dynamically creating a qvd file name. in QlikView

Dynamically creating a qvd file name.

Re: Dynamically creating a qvd file name.