Easy LOAD only with manual data

[sculptorlv]

Hello!

I've fond out that I can't solve an esay issue

I need to add such calculation in my qlikview scrip code:

     IF(WEEKDAY(Today()) = 0, Today()-3, Today())

Can I use LOAD somehow withot actually loading an external data?

For example:

LOAD

     DATE(IF(WEEKDAY(Today()) = 0, Today()-3, Today()))          AS Date_Needed

;

My example will not work, because there is no Resident or a file for import. How can I dedine this parameter Date_needed in my scirp?

[tresB · Accepted solution]

Try like:

LOAD

     DATE(IF(WEEKDAY(Today()) = 0, Today()-3, Today()))          AS Date_Needed

AutoGenerate 1;

[sculptorlv]

Thank you !!