topic Re: Problems with AVG (Skip values=0) in QlikView

Problems with AVG (Skip values=0)

Wed, 25 Nov 2020 16:16:04 GMT

Hi.

I have in my database a numeric column, but I need to make avg without taking into account records with value 0.

I'm showing the avg result in a text object , but It takes into count the values =0 and the result varies greatly from what I expect.

My expression in the text object is:

And my BD is:

thanks for your help.

sunny_talwar — Wed, 18 May 2016 22:22:09 GMT

Try this:

Avg({<PREGUNTA615_24 = {'>0'}>}PREGUNTA615_24)

swuehl — Wed, 18 May 2016 22:32:00 GMT

Or (assuming you want to consider user selections) use the intersection operator *

=Avg({<PREGUNTA615_24 *= {">0"}>} PREGUNTA615_24)

=Avg({<PREGUNTA615_24 -= {0.00}>} PREGUNTA615_24)

or not using set analysis

=Avg( If(PREGUNTA615_24 <> 0, PREGUNTA615_24))

sunny_talwar — Wed, 18 May 2016 22:33:39 GMT

sunny_talwar — Thu, 19 May 2016 15:07:39 GMT

And once again.

Man I have to be more descriptive in my responses and cover all possibilities. I am getting there