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

[#1]

Good Afternoon,

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

Example: NomeArquivo2013jul.qvd

Att,

JH

[shree909]

Hi ty this

left(NomeArquivo2013jul,11)           AS  Filename,

mid(NomeArquivo2013ju,11,4)      AS Year,

Right(NomeArquivo2013ju,3)          AS  Month

Thanks

[#3]

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]

You need to do something like that:

STORE

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

[#5]

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]

Use:

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

STORE

INTO $(NomeArquivo);

[Sokkorn · Accepted solution]

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]

Hi

Check the attached qlikview file

Regards

Harsha

[#9]

thanks for the help!