topic Re: Average of average?! in QlikView

Average of average?!

ivan_will — Fri, 14 Sep 2012 14:32:29 GMT

Hi, have a chart with a dimension Supplier and an expression average customers per day.

Here is the expression: Avg( Aggr( Count(DISTINCT [Customer]),Date, [Supplier]))

Want in another expression to make the total average for all suppliers For example:

Supplier 1 - 10 average for all - 15

Supplier 2 - 20 average for all - 15

So how to make the expression (Avg( Aggr( Count(DISTINCT [Customer]),Date, [Supplier]))) to do that?

Thanks

swuehl — Fri, 14 Sep 2012 14:37:59 GMT

Maybe

=Avg( Aggr( Count(DISTINCT [Customer]),Date))

=Avg(TOTAL Aggr( Count(DISTINCT [Customer]),Date, [Supplier]))

ivan_will — Fri, 14 Sep 2012 14:40:37 GMT

Nope , it doesn't work.

whiteline — Fri, 14 Sep 2012 14:55:41 GMT

I guess we missed the point.

Could you explain what the 'Supplier 1 - 10' and Supplier 2 - 20' is?

ivan_will — Fri, 14 Sep 2012 15:04:41 GMT

Supplier / average customers per day / average for all suppliers

1 10 20

2 20 20

3 30 20

whiteline — Fri, 14 Sep 2012 15:33:05 GMT

and you want ?

swuehl — Fri, 14 Sep 2012 15:39:24 GMT

Try

=avg(total aggr(avg(aggr(count(DISTINCT Customer),Supplier,Date)),Supplier))

Or please post some sample lines of your input data.