Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try like:
LOAD
DATE(IF(WEEKDAY(Today()) = 0, Today()-3, Today())) AS Date_Needed
AutoGenerate 1;
Try like:
LOAD
DATE(IF(WEEKDAY(Today()) = 0, Today()-3, Today())) AS Date_Needed
AutoGenerate 1;
Thank you !!