Simple Exponential Smoothing in Qlikview

[mdmukramali]

Dears,

Looking to Implement Simple Exponential Smoothing in Qlikview.

does anyone have any example to related to this ?

Thanks,

Mohammed Mukram 

[Anil_Babu_Samineni]

Which object?

[mdmukramali]

Hi,

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

let me explain the scenario :

Year	Sales
2010	250
2011	450
2012	150
2013	240
2014	120
2015	180
2016	260
2017	400
2018	240
2019

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

@Anil_Babu_Samineni @sunny_talwar

Thanks,

Mohammed Mukram 

[sunny_talwar · Accepted solution]

Ran into an issue, posted a new thread

Above function with column reference