Qlik Community

New to Qlik Sense

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

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

exclude nulls

Hi all,

I want to exclude the  null values from the measure.





Labels (1)
1 Reply
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:

Help users find answers! Don't forget to mark a solution that worked for you!