Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhagi
Contributor II
Contributor II

exclude nulls

Hi all,

I want to exclude the  null values from the measure.

sum(Test1)/sum(Test2)

 

 

 

Labels (1)
1 Reply
joaopaulo_delco
Partner - Creator III
Partner - Creator III

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)
Help users find answers! Don't forget to mark a solution that worked for you!