# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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

Tags (2)
1 Solution

Accepted Solutions
MVP

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

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

Thanks,

Mohammed Mukram

MVP

## Re: Simple Exponential Smoothing in Qlikview

Ran into an issue, posted a new thread

Above function with column reference