Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Forecasted years do not appear

Hi there,

Hope someone has a brainwave to help me out.

Just uploaded a forecast file (to and incl. 2015) but those values are not appearing the calendar is restricted to 2013.

  • Does anyone have an idea of how I can extend the calendar (script)?
  • Do I have to create a separate calendar for the forecast?

I've attached the existing script for the calendar.

Thanks,
René

1 Solution

Accepted Solutions
MVP
MVP

Re: Forecasted years do not appear

Probably because you used yearend(today()) for vMaxDate.

LET vMinDate = num(peek('MinDate'));

LET vMaxDate = num(yearend(today()));

Try replacing it with

LET vMaxDate = num(peek('MaxDate'));

2 Replies
MVP
MVP

Re: Forecasted years do not appear

Probably because you used yearend(today()) for vMaxDate.

LET vMinDate = num(peek('MinDate'));

LET vMaxDate = num(yearend(today()));

Try replacing it with

LET vMaxDate = num(peek('MaxDate'));

Not applicable

Re: Forecasted years do not appear

Thanks Swuehl. That indeed solved the issue.

Regards,

René

Community Browser