Simple Exponential Smoothing in Qlikview

mdmukramali — Thu, 29 Nov 2018 20:26:35 GMT

Dears,

Looking to Implement Simple Exponential Smoothing in Qlikview.

does anyone have any example to related to this ?

Thanks,

Mohammed Mukram

Re: Simple Exponential Smoothing in Qlikview

Anil_Babu_Samineni — Fri, 30 Nov 2018 04:07:24 GMT

Which object?

mdmukramali — Fri, 30 Nov 2018 10:32:32 GMT

Hi,

i want the Result in the Chart ( Bar chart or Straight Table).

let me explain the scenario :

I have Year and Sales :

Now i want to calculate the Simple exponential smoothing value.

formula:

Simple exponential smoothing = Last Year Simple exponential smoothing +(0.5 *(LastYear Sales- Last Year Simple exponential smoothing ))

Let's assume Sales =S and Simple exponential smoothing =F

the formula :

Simple exponential smoothing = F +( 0.5*(S-F))

Year	Sales	Simple Exponential Smoothing
2010	250	First Year it should be Null
2011	450	250 (Sales of last Year)
2012	150	350 (Calculations should start from this Year
2013	240	250
2014	120	245
2015	180	183
2016	260	181
2017	400	221
2018	240	310
2019		275

formula for Year 2014 Simple exponential smoothing (Excel Cell 4) ==C3+(0.5*(B3-C3))

Thanks,

Mohammed Mukram

sunny_talwar — Fri, 30 Nov 2018 12:47:54 GMT

Ran into an issue, posted a new thread