Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
francisvandergr
Partner - Creator II
Partner - Creator II

Making QVD with dynamic name

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;



1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

3 Replies
Not applicable

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

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.