How to exclude 0 values in an average calculation?

[Anonymous]

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

[kaushiknsolanki]

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

[Anonymous]

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.

[Thiago_Justen_]

One way of doing this is:

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