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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with let and today

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());

Labels (1)
1 Solution

Accepted Solutions
its_anandrjs
Champion III
Champion III

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

View solution in original post

3 Replies
its_anandrjs
Champion III
Champion III

Hi,

You can try this way also by the below documents.

Store Qvd with timestamp value

Regards

Anand

its_anandrjs
Champion III
Champion III

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

Not applicable
Author

Try with:

LET vDate = FLOOR(today());

or

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



SET vQVD_File = Photo_$(vDate).qvd;

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