topic Re: Average Count in QlikView

Average Count

Anonymous — Tue, 05 Apr 2016 13:57:21 GMT

Hi All

Need some help please.

I am trying to do the following

=avg(Count(Field1))/(Count(Field2))

I am getting Error in Expr - Nested Aggr not allowed

Basically i want to

count Field1 (eg 10)

Divide by

Count Field2 (eg 5)

Answer ....(eg 2)

And i want the average in percentage (eg. 20%)

In Text object.

Thanks All

Re: Average Count

sunny_talwar — Tue, 05 Apr 2016 13:59:41 GMT

10/5 will be 200%, right:

You can do Count(Field1)/Count(Field2) and then use formatting on the numbers tab to show it as percentage

Re: Average Count

swuehl — Tue, 05 Apr 2016 14:00:20 GMT

The average needs a dimension, assuming DIM field:

=Avg(Aggr( Count(Field1)/Count(Field2) , DIM))

Re: Average Count

Anonymous — Tue, 05 Apr 2016 14:04:24 GMT

Though this was right i needed average

Re: Average Count

Anonymous — Tue, 05 Apr 2016 14:04:37 GMT

Thanks Sunny

Re: Average Count

Anonymous — Tue, 05 Apr 2016 14:05:16 GMT

This actually came up right

Thanks Swuehl and for explaiunging

Re: Average Count

Anonymous — Tue, 05 Apr 2016 14:05:53 GMT

Swuehl and Sunny......you guys got a competition going on?

Re: Average Count

sunny_talwar — Tue, 05 Apr 2016 14:18:05 GMT

There can be no competition between Stefan and me Adil. He is a genius and I am still 10% (or may be less) level of where he is. Everyday I learn new things from him and I am thankful to him for being there for all of us whenever we need something