topic Making QVD with dynamic name in QlikView

Making QVD with dynamic name

francisvandergr — Tue, 22 Mar 2011 15:30:34 GMT

In wanna make a qvd with a date in the name. see above. Can someone explain what is wrong in this line ?

store $(d) into $(vDataDir)\$(d)$(vToday).QVD;

Tue, 22 Mar 2011 15:33:07 GMT

Hi,

did you try to generate a file manually with the date-format of QV?

Maybe the file-system doesn't accept the separators ==> : of the date?

only estimated, the format seems correct..

HTH

Oleg_Troyansky — Tue, 22 Mar 2011 15:38:13 GMT

Most likely, your date format includes some of the characters that Windows doesn't allow in file names, like slash, for example.

Format your date using dots or underscores and it should work. For example:

let vDate = Date(myDate, 'YYYY_MM_DD');

Miguel_Angel_Baeyens — Tue, 22 Mar 2011 15:42:08 GMT

Hello,

That should work, but since there may be slashes, I'd enclose the name of the file replacing those characters:

LET vNombreArchivo = Date(Today(), 'YYYY_MM_DD'); store $(d) into [$(vDataDir)\$(d)$(vToday).QVD];

Hope that helps.

EDITed: previous code didn't make sense.