Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
Looking to Implement Simple Exponential Smoothing in Qlikview.
does anyone have any example to related to this ?
Thanks,
Mohammed Mukram
Ran into an issue, posted a new thread
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
Ran into an issue, posted a new thread