topic Re: Calculated Average from Average in QlikView

Calculated Average from Average

Thu, 25 Apr 2013 17:48:46 GMT

Hi,

In the below formula I don't know what I am doing wrong.

=Avg(Avg(D2-D1) + Avg(D3-D2) + Avg(D4-D3))

I am using this formula in a expression for a speedometer chart to calculate the average no of days between D1 to D4.

Your help is very much appreciated.

Thanks!!

rphpacheco — Thu, 25 Apr 2013 17:57:23 GMT

QlikView does not accept average to average

Thu, 25 Apr 2013 18:00:02 GMT

Then how can I achieve it? May be percentage would be good idea?

Please suggest.

rphpacheco — Thu, 25 Apr 2013 18:05:53 GMT

As these dates are formatted?

Could you post an example?

Thu, 25 Apr 2013 18:25:39 GMT

Hello Pacheco,

I attched the qvw file above. I am usign the speedometer chart.

rphpacheco — Thu, 25 Apr 2013 19:34:37 GMT

calvindk — Thu, 25 Apr 2013 20:03:27 GMT

You can wrap it inside an aggregation as well, to do an avg(aggr(avg(D1to3),Dimensions))

Your dimensions for the aggr should be anything the user can select based on.

Edited for clarity using your expression:

Avg(Aggr(Avg(D2-D1) + Avg(D3-D2) + Avg(D4-D3)), Dimensions)

rphpacheco — Fri, 26 Apr 2013 12:02:43 GMT

I tried this way also Anders, but for the example that qvw SAARU sent did not work.

jagan — Fri, 26 Apr 2013 14:13:59 GMT

Hi,

Try using RangeAve

=RangeAvg(Avg(D2-D1), Avg(D3-D2), Avg(D4-D3))

Hope this helps you.

Regards,

Jagan.