topic Re: Accumulative Sums and Range AVG in QlikView

Accumulative Sums and Range AVG

demcug82 — Thu, 07 Apr 2016 14:08:59 GMT

Hi All,

I'm trying to get in a line chart , a moving average of 20 periods of a accumulative sums of amount .
Amount can be both positive and negative .

I have the dimension "Data" and Measure: "Quantità"

I load data for semplicity with Inline only 4 rows and i tried with a moving average of 3 periods.

I tried for accumulative : Accumulate Option and rangesum but no works

The wrong column it's "EquityLine" in the 4° row

Any idea?

Demetrio

Chanty4u — Thu, 07 Apr 2016 16:07:22 GMT

hi ,

sunny_talwar — Thu, 07 Apr 2016 16:08:45 GMT

How are you calculating 132.33? Can you elaborate?

sunny_talwar — Thu, 07 Apr 2016 16:14:28 GMT

Try this expression:

=RangeAvg(Above(RangeSum(Above(Sum({<Data=>} [Quantità]), 0, RowNo())), 0, 3))

demcug82 — Fri, 08 Apr 2016 08:08:53 GMT

Tyvm Sunny!!!

Now Works