Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Remove null values from measures?

To remove Null from dimension, we uncheck the Show Null check-box. Now my question is when i create a measure the show null value option is not available so how can i remove null values from the measure that i created? or if u can provide me with an alternate method to remove null values from measures.

Thank you in advance.

3 Replies

Open the chart properties, then go to

Add-Ons -> Data processing (or similar, 'Data handling'? I am not using the english version) -> Disable 'Show NULL values'

Specialist II
Specialist II

Hi Brazil,

Try the following formula like method, if you think a null value as 0:

=if(your expression=0,'',your expression)

Then you should disable show null values.

If you already have Null as measure, just uncheck the sow nulls chechkbox.


Not applicable

you could add the measure into an IF statement in your dimension:


then when you hide nulls on this dimension, it will hide your null measures.