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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

master calendar error new?

Field not found - <–>

TempCalendar:

Load

date( + rowno()-1) As TempDate

Autogenerate 1

While

–+1

script i have like:

set varMinDate='01/01/2014';

let varMinDate=date(today);

TempCalendar:

Load

date($(varMinDate) + rowno()-1) As TempDate

Autogenerate 1

While

$(varMaxDate)–$(varMinDate)+1;

MasterCalendar:

Load

TempDate As OrderDate,

Week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month

resident TempCalendar;

Labels (1)
1 Reply
Not applicable
Author

Hi,

When you set your variable varMinDate use today function but you miss tip "()" after today, the correct sentence is:

LET varMinDate = Date(today(),'DD/MM/YYYY'); // or specify time format that you need.

If you just tip today without "()" you get "-" (incorrect value).

Best regards.