topic Re: Average Dynamically in QlikView

Average Dynamically

Anonymous — Mon, 30 Jun 2014 05:25:38 GMT

Hi All,

I have an issue to calculate average dynamically as Cummulative average at front end

PFA my sample file.

I have Year Month as dimension and sum(APE) as expression.

Now I want to calculate MAPE which is average of values calculated as cummulative summation.

MAPE CAlculation is >>

2014-01 = average(B$2)

2014-02 = average(B$2:B3)

2014-03 = average(B$2:B4) ........................ and so on

Please help me in achieving it...

Mon, 30 Jun 2014 06:50:50 GMT

Hi Nitin,

Use this expression to calculate running average , i tried it and its working

=Num(RangeSum(Above(Sum(APE),0,RowNo()))/RowNo(),'#,##0.00')

I have also attached QVW, PFA

Regards,

Vivek

jonathandienst — Mon, 30 Jun 2014 06:53:10 GMT

Actually a little simpler:

RangeAvg(Above(Sum(APE),0,RowNo()))

HTH

Jonathan

Mon, 30 Jun 2014 07:00:40 GMT

Hi Try this

RangeAvg(Above(column(1),0,rowno()))

hope this will helps you