Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Sokkorn
Master
Master

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

View solution in original post

8 Replies
shree909
Partner - Specialist II
Partner - Specialist II

Hi ty this

left(NomeArquivo2013jul,11)           AS  Filename,

mid(NomeArquivo2013ju,11,4)      AS Year,

Right(NomeArquivo2013ju,3)          AS  Month

Thanks

Not applicable
Author

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
Partner - Creator
Partner - Creator

You need to do something like that:

STORE

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

Not applicable
Author

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
Partner - Creator
Partner - Creator

Use:

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

STORE

INTO $(NomeArquivo);

Sokkorn
Master
Master

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

Anonymous
Not applicable
Author

Hi

Check the attached qlikview file

Regards

Harsha

Not applicable
Author

thanks for the help!