Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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 🙂