Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
juleshartley
Valued Contributor

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!

Tags (3)
1 Solution

Accepted Solutions
juleshartley
Valued Contributor

Re: Script error - master calendar

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

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

1 Reply
juleshartley
Valued Contributor

Re: Script error - master calendar

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

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

Community Browser