Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

how I could create a QVD with the filename + year + month reload?

Good Afternoon,

how I could create a QVD with the filename + year + month reload?

Example: NomeArquivo2013jul.qvd

Att,

JH

Tags (1)
1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Re: how I could create a QVD with the filename + year + month reload?

Hi,

This should work:

Let vFileName = Year(ReloadTime()) & Month(ReloadTime());

[TABLE]:

LOAD * INLINE [

    teste, codigo

    1, 3

    2, 4];

STORE [TABLE] INTO [ C:\Users\Avacon\Desktop\$(vFileName).qvd];

Regards,

Sokkorn

8 Replies
shree909
Valued Contributor II

Re: how I could create a QVD with the filename + year + month reload?

Hi ty this

left(NomeArquivo2013jul,11)           AS  Filename,

mid(NomeArquivo2013ju,11,4)      AS Year,

Right(NomeArquivo2013ju,3)          AS  Month

Thanks

Not applicable

Re: how I could create a QVD with the filename + year + month reload?

Sorry,

but I did not, I need to put the name in arquivo.qvd

example

STORE [TABLE] INTO [$ (vdir) \ QlikView Year Month. QVD];

Year and month would be according to the month and year of the reload!

eddysanchez
Contributor

Re: how I could create a QVD with the filename + year + month reload?

You need to do something like that:

STORE

INTO 'NomeArquivo' & Year(ReloadTime()) & Month(ReloadTime()) & '.qvd';

Not applicable

Re: how I could create a QVD with the filename + year + month reload?

Sorry,

but there's no way to work, I had passed this command, but he writes everything I step STORE:

example:

'FileName' & Year (ReloadTime () & Month (ReloadTime ()). QVD

what am I doing wrong?

[TABLE]:

LOAD * INLINE [

    teste, codigo

    1, 3

    2, 4

];

STORE [TABLE] INTO [ C:\Users\Avacon\Desktop\'NomeArquivo' & Year(ReloadTime()) & Month(ReloadTime()) & '.qvd'];

eddysanchez
Contributor

Re: how I could create a QVD with the filename + year + month reload?

Use:

LET NomeArquivo = 'C:\Users\Avacon\Desktop\NomeArquivo' & Year(ReloadTime()) & Month(ReloadTime()) & '.qvd';

STORE

INTO $(NomeArquivo);

Sokkorn
Honored Contributor

Re: how I could create a QVD with the filename + year + month reload?

Hi,

This should work:

Let vFileName = Year(ReloadTime()) & Month(ReloadTime());

[TABLE]:

LOAD * INLINE [

    teste, codigo

    1, 3

    2, 4];

STORE [TABLE] INTO [ C:\Users\Avacon\Desktop\$(vFileName).qvd];

Regards,

Sokkorn

sriharsha96
Contributor II

Re: how I could create a QVD with the filename + year + month reload?

Hi

Check the attached qlikview file

Regards

Harsha

Not applicable

Re: how I could create a QVD with the filename + year + month reload?

thanks for the help!

Community Browser