topic How to exclude 0 values in an average calculation? in App Development

How to exclude 0 values in an average calculation?

Anonymous — Sat, 28 Apr 2018 16:10:17 GMT

If I have different fields whit for example 2 3 0 values how can I exlude that 0 value in the calculation in Qlik Sense?

Thanks

Re: How to exclude 0 values in an average calculation?

kaushiknsolanki — Sun, 29 Apr 2018 06:27:12 GMT

Hi,

There are multiple ways of doing it.

You can use if statements in script and get rid of those values.

If you still need those for some other calculations then you can flag them in script.

You can also use set analysis in front end to avoid those records from calculations.

Regards,

Kaushik Solanki

Re: How to exclude 0 values in an average calculation?

Anonymous — Sun, 29 Apr 2018 09:42:38 GMT

Thanks,

Yeah, I have to do the average of four numbers but sometimes there's in one field with zero values, so in those cases I want to do the average over three number.

Re: How to exclude 0 values in an average calculation?

Thiago_Justen_ — Sun, 29 Apr 2018 15:36:04 GMT

One way of doing this is:

Avg ({<Value={">0"}>}Value)