Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

How to add predicted days?

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