Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
demcug82
New Contributor III

Accumulative Sums and Range AVG

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


dee.png




1 Solution

Accepted Solutions

Re: Accumulative Sums and Range AVG

Try this expression:

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

Capture.PNG

View solution in original post

4 Replies
Chanty4u
Esteemed Contributor III

Re: Accumulative Sums and Range AVG

Re: Accumulative Sums and Range AVG

How are you calculating 132.33? Can you elaborate?

Re: Accumulative Sums and Range AVG

Try this expression:

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

Capture.PNG

View solution in original post

demcug82
New Contributor III

Re: Accumulative Sums and Range AVG

Tyvm Sunny!!!

Now Works