Forecasting in Qlikview/Qliksense

[manojkulkarni]

Good Morning All,

I am looking for suggestion or solution to draw a forecasting line using the 2 or 4 weeks average calculation on current data till the it reaches 0. Below is the sample data on which i am trying the solution. Any help will be much appreciated and thanks in advance.

Week Start	Open
20-Jun-2022	271
27-Jun-2022	273
04-Jul-2022	275
11-Jul-2022	275
18-Jul-2022	276
25-Jul-2022	275
01-Aug-2022	275
08-Aug-2022	275
15-Aug-2022	270
22-Aug-2022	268
29-Aug-2022	267
05-Sep-2022	265
12-Sep-2022	260

[Mario_De_Felipe]

Hi @manojkulkarni 

You could use a simple linear regression using chart functions:

linest_M(total aggr(Open,[Week Start]),[Week Start])*[Week Start] + linest_b(total aggr(Open,[Week Start]),[Week Start])

You could see and example here: https://aginic.com/blog/forecasting-in-qlik-guide/ 

Hope it helps!