How to add predicted days?

[Edytagra]

Hi guys,

I found helpful article how to make forecasting step by step: https://aginic.com/blog/qlik/forecasting-in-qlik-guide/

I have done step 3. and get the bar chart with no predcited days. I am doing forecasting for the dimension DAY, for the next 30 days from max date (which is 31.12.2018).

TempMaxDate:
Load
Max([Day]) as LastDay
Resident [PAZ2018];

Let vOLastDay = Peek([LastDay],0,TempMaxDate);
Let vNextDay = $(vLastDay)+31;

Trace $(vLastDay);

Drop table TempMaxDate;

[PAZ2018]:
Load*
Resident [PAZ2018];
Concatenate

TempDates:
Load $(vLastDay)+IterNo() as [Day]
AutoGenerate (1)
WHILE $(vLastDay)+IterNo() <= $(vNextDay);