Discussion Board for collaboration on QlikView Scripting.
could anyone help with why I might be getting a script error with simple calendar build:
//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
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.
Go to Solution.
Answered my own question again - it's the dreaded apostrophes!
Needs to be Load Date('$(vStart)' + RecNo.. etc