Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
mdmukramali
Valued Contributor III

Simple Exponential Smoothing in Qlikview

Dears,

 

Looking to Implement Simple Exponential Smoothing in Qlikview.

 

does anyone have any example to related to this ?

 

Thanks,

Mohammed Mukram 

 

1 Solution

Accepted Solutions

Re: Simple Exponential Smoothing in Qlikview

Ran into an issue, posted a new thread

Above function with column reference

3 Replies

Re: Simple Exponential Smoothing in Qlikview

Which object?
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
mdmukramali
Valued Contributor III

Re: Simple Exponential Smoothing in Qlikview

Hi,

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

let me explain the scenario :

YearSales
2010250
2011450
2012150
2013240
2014120
2015180
2016260
2017400
2018240
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))

YearSalesSimple Exponential Smoothing
2010250 First Year it should be Null
2011450250 (Sales of last Year)
2012150350 (Calculations should start from this Year
2013240250
2014120245
2015180183
2016260181
2017400221
2018240310
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 

 

 

Re: Simple Exponential Smoothing in Qlikview

Ran into an issue, posted a new thread

Above function with column reference