Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I just tried the Qlik "Building an App" tutorial and found myself with a script error while creating the master calendar. Is it user error on my part, or is there indeed a typo in the tutorial. Any help in getting past this would be greatly appreciated. Here's the error message:
Script line error: : TempCalendar: LOAD DATE( + ROWNO() -1) AS TempDate AUTOGENERATE - +1
And here's my script code that I copy/pasted from page 33 of "Qlik Sense Tutorial - Building an App.pdf"
LET varMinDate = NUM(PEEK('Date',0,'Sales data'));
LET varMaxDate = NUM(PEEK('Date',-1,'Sales data'));
TempCalendar:
LOAD
DATE($(varMinDate) + ROWNO() -1) AS TempDate
AUTOGENERATE $(varMaxDate) - $(varMinDate) +1;
// Create the Master Calendar
MasterCalendar:
LOAD
DATE(TempDate) AS Date,
WEEK(TempDate) AS Week,
YEAR(TempDate) AS Year,
MONTH(TempDate) AS Month,
DAY(TempDate) AS Day,
INYEARTODATE(TempDate,'2014-03-31', 0) *-1 AS CYTDFlag,
INYEARTODATE(TempDate,'2013-03-31',0) *-1 AS LYTDFlag,
DATE(MONTHSTART(TempDate), 'MMM-YYYY') AS MonthYear,
'Q' & CEIL(MONTH(TempDate)/3) AS Quarter,
WEEK(TempDate)&'-'&YEAR(TempDate) AS WeekYear,
WEEKDAY(TempDate) AS WeekDay
RESIDENT
TempCalendar
Order BY
TempDate ASC;
DROP FIELD TempDate;
Thanks Rob. I make the changes to the peek functions and that fixed it. As a complete first-timer trying the product out, and attempting to simply follow the provided instructions, I really appreciate that there's this community to help me get past mistakes in the material. Thanks to all!
Glad you got it working and welcome to the Community. Please mark one of the answers as "correct" to close the thread.
-Rob
Hi Ed,
We have updated the tutorial source files for the next release.
Many thanks for spotting this.
Best regards,
Thomas