Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to exclude the null values from the measure.
sum(Test1)/sum(Test2)
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)