Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
parthakk
Creator II
Creator II

Qlik Sense - Suppress Null Value of Expression

Hi Everyone,

I am using a table where i have multiple dimensions and an expression. If my expression yields null or zero value then that entire row should get hidden.

In QlikView we use to achieve it by suppressing null and suppressing zero value option in properties but i dont find it here.

I am not comparing QlikSense with QlikView but i want to achieve a similar result.

Kindly suggest how can i achieve this.

Thanks,

Partha K

5 Replies
OmarBenSalem

under complement, uncheck this:

Capture.PNG

parthakk
Creator II
Creator II
Author

Hi Omar,

Thanks for the quick reply. But this does not work for expression.

Thanks,

Partha K

beck_bakytbek
Master
Master

Hi Partha,

how does look your expression?

parthakk
Creator II
Creator II
Author

Hi Beck,

A small correction to my question. I have 3 expression and out of these 3 one expression, yields output as 1/0.

So based on this expression i need to hide the row.

Thanks,

Partha K

beck_bakytbek
Master
Master

Hi Partha,

can you show your example? (as expression)