exclude nulls

[bhagi]

Hi all,

I want to exclude the  null values from the measure.

sum(Test1)/sum(Test2)

[joaopaulo_delco]

Hi @bhagi !

      By default, Qlik Sense exclude the null() values from measure automatically. 

But if you want to desconsider null values from some dimension, you can do on set analysis like below:

sum({<Your_Dimension-={"-"}>}Test1)/sum({<Your_Dimension-={"-"}>}Test2)