Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

QVD with File Creation Date

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: QVD with File Creation Date

The code works for me at my place.

Have you checked the correct location for the file?

View solution in original post

5 Replies
Highlighted
MVP
MVP

Re: QVD with File Creation Date

The code works for me at my place.

Have you checked the correct location for the file?

View solution in original post

Highlighted
Contributor

Re: QVD with File Creation Date

that code works on my machine too.

Highlighted
Partner
Partner

Re: QVD with File Creation Date

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

Highlighted
Honored Contributor

Re: QVD with File Creation Date

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

Highlighted
Contributor

Re: QVD with File Creation Date

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