QVD with File Creation Date

[rxp03570]

Hi All,

I'm trying to generate a QVD with FileCreation Date. I'm using the below script and variable:

Let vFileCreationMonth= Date(Today(),'MMYYYY');

[Data Info]:

Load * Inline [

Products,Sales

Routers.100

Switches.2399

];

Store [Data Info] into [lib://FolderPath/Qlikview\QVD\DataInfo_$(vFileCreationMonth).qvd](qvd);

Using the above script the QVD is not being generated, the reload is successful not sure what the issue is.

Thanks

[swuehl · Accepted solution]

The code works for me at my place.

Have you checked the correct location for the file?

[achettipalli]

that code works on my machine too.

[Mark_Little]

HI

As suggested the code looks fine.

Check the location and make sure you have the rights need.

Make sure you variable is being populated also.

Trace $(vFileCreationMonth);

Mark

[beck_bakytbek]

Hi Rahul,

try this:

let vFileDate = Date(today(); 'DD-MM-YY');

temp:

load Your data;

Store [your Table] into [your Table]  $FileDate).qvd(qvd);

i hope that helps

Beck

[rxp03570]

Thanks for the reply, had some access issues. The code seems to work fine.