Forecasting in Qlikview/Qliksense

manojkulkarni — Wed, 14 Sep 2022 05:40:33 GMT

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

Re: Forecasting in Qlikview/Qliksense

Mario_De_Felipe — Tue, 27 Sep 2022 07:40:02 GMT

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!

topic Forecasting in Qlikview/Qliksense in App Development

Forecasting in Qlikview/Qliksense

Re: Forecasting in Qlikview/Qliksense