Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
One way of doing this is:
Avg ({<Value={">0"}>}Value)