Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Edytagra
Contributor II
Contributor II

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

Labels (4)
0 Replies