Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
juleshartley
Specialist
Specialist

Script error - master calendar

Hi,

could anyone help with why I might be getting a script error with simple calendar build:


//DATE TABLE

//create a table with all dates between the start and end date

Let vEnd = Monthend(Today());

let vStart = AddYears('$(vEnd)',-1); //1 year of dates

Calendar:

Load  Text(Date(TEMPDATE,'DDMMYYYY')) as %Key_Date... ;

Load Date($(vStart) + RecNo()) as TEMPDATE autogenerate $(vEnd) - $(vStart) ;

The error seems to occur in the last line.

Thanks!

1 Solution

Accepted Solutions
juleshartley
Specialist
Specialist
Author

Answered my own question again - it's the dreaded apostrophes!

Needs to be Load Date('$(vStart)' + RecNo.. etc

View solution in original post

1 Reply
juleshartley
Specialist
Specialist
Author

Answered my own question again - it's the dreaded apostrophes!

Needs to be Load Date('$(vStart)' + RecNo.. etc