topic Re: AVG expression in QlikView

AVG expression

Mon, 16 Sep 2013 07:06:10 GMT

Hello

I have an expression in a table

max([Actual Completion Date]) - min([Actual Start Date])

I would like to have the average of this expression

Avg(max([Actual Completion Date]) - min([Actual Start Date]) )

This does not work.

The min and max is dependent on dimensions, I know.

Any ideas how to solve this?

Mon, 16 Sep 2013 07:08:28 GMT

Hi ,

Try this interval(Avg(max([Actual Completion Date]) - min([Actual Start Date]) ))

tresB — Mon, 16 Sep 2013 07:09:21 GMT

I guess you have to use TOTAL keyword (though that depends on your requirement).

Gysbert_Wassenaar — Mon, 16 Sep 2013 07:50:59 GMT

If you need to nest aggregation functions you need to use the aggr function:

avg(aggr((max([Actual Completion Date]) - min([Actual Start Date]),Dim1, Dim2 ... ))

Replace Dim1, Dim2 ... with the dimensions over which min and max need to be aggregated.

Mon, 16 Sep 2013 09:56:34 GMT

It worked!

Hats off!