topic Re: Problem with let and today in QlikView

Problem with let and today

Tue, 13 Jan 2015 14:01:17 GMT

Hi everybody.

Why i cant have this ?

LET Date = date(today());

I can do this SET Date =date(today());

BUT the problem is that i wanna to save this in this way

STORE tabe INTO [..\Photo_$(Date).qvd];

and if i do the variable with set i'll have photo_date(today())

but if i do the same with let i'd have the date, not the function.

For example i did this with let and it worked, but i want to have only the normal date.

LET Date = year(Today())*100+month(Today());

its_anandrjs — Tue, 13 Jan 2015 14:06:37 GMT

Hi,

You can try this way also by the below documents.

Regards

Anand

its_anandrjs — Tue, 13 Jan 2015 14:28:34 GMT

Hi,

Also for your problem for this script STORE table INTO [..\Photo_$(Date).qvd];

You can try with store the path into the variable

SET Date2 = date(today());
Let Date3 = $(Date2);

LET vPath = '..\';

STORE Tab2 into $(vPath)$(Date).Qvd;

Regards

Anand

Tue, 13 Jan 2015 16:15:34 GMT

Try with:

LET vDate = FLOOR(today());

LET vDate = DATE(today(), 'YYYYMMDD');

SET vQVD_File = Photo_$(vDate).qvd;

STORE tabe INTO [..\$(vQVD_File)];