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);
