topic Easy LOAD only with manual data in QlikView

Easy LOAD only with manual data

sculptorlv — Mon, 26 Jan 2026 18:19:17 GMT

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 — Tue, 25 Sep 2018 06:43:33 GMT

Try like:

LOAD

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

AutoGenerate 1;

sculptorlv — Tue, 25 Sep 2018 06:46:19 GMT

Thank you !!