topic Re: Incorrect Result using Avg() in QlikView

Incorrect Result using Avg()

Wed, 08 Apr 2015 13:53:17 GMT

Hello All,

I have data with null values in Qty on which I am trying to apply Avg()

Can I achieve it simply by using Avg() only & not by Sum()/Count() method?

Regards

Kiran

P.S. I have attached sample qvw for further information.

anlonghi2 — Wed, 08 Apr 2015 14:04:14 GMT

Hello Kiran,

try with this:

Avg(if(isnum(Quantity),Quantity,0))

Best regards

sunny_talwar — Wed, 08 Apr 2015 14:07:40 GMT

Try this expression:

=Avg(Aggr(Sum(If(IsNull(Quantity), 0, Quantity)), [Material Code]))

HTH

Best,

Sunny

Wed, 08 Apr 2015 14:18:41 GMT

Hi Kiran,

I think a possible solution could be replace null values with zeros in script.

Best Regards

Pablo