Handling Nulls in Measures | Qlik Sense

[AnkitMadhukar]

Hi Everyone ,

I am working on a visual(table) which has more than one measure.
And for one of the measures I don't want null values to be displayed in the table.

I did uncheck the 'include zero values' in Addon.

But I think qlik doesnot filter the row based on just one measure , all the measures need to be null for it to work.
Is this correct?
If so are there any approaches to filter rows even when one of the measures is null.

I only want the rows for which value is present in the measure 1 column

thanks
Best Regards,
Ankit 

[MayilVahanan · Accepted solution]

HI @AnkitMadhukar 

I think qlik doesnot filter the row based on just one measure , all the measures need to be null for it to work. <-- yes, its correct.

I only want the rows for which value is present in the measure 1 column
<-- Try like below in the measure 2, 
if(Measure1 >0, Measure2)

Hope it helps

[AnkitMadhukar]

Thanks @MayilVahanan  ,
Yeah just figured that out , need to add that condition to all the measures in the view.
Not that user friendly to be honest 🙂