4 Replies Latest reply: Jun 14, 2014 5:30 PM by Leslie Blumenfeld RSS

    Calculate Extended Moving Average  (EMA)

    Leslie Blumenfeld

      Does anyone have an example of a QlikView expressio to calculate an "x" period exponential moving average (EMA)? I know how to do a simple (rolling) average using RangeAvg() and Above(), but an EMA is more complex, because it uses the prior record's EMA.

       

      "x" can be any number you'd like (e.g. 50, 200, etc.)

       

      Thanks.