topic Re: Handling Nulls in Measures | Qlik Sense in App Development

Handling Nulls in Measures | Qlik Sense

AnkitMadhukar — Mon, 20 Dec 2021 21:08:46 GMT

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

Re: Handling Nulls in Measures | Qlik Sense

MayilVahanan — Tue, 10 Nov 2020 07:24:14 GMT

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

Re: Handling Nulls in Measures | Qlik Sense

AnkitMadhukar — Tue, 10 Nov 2020 07:30:16 GMT

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 🙂