Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
parthakk
Contributor 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
Partner
Partner

Re: Qlik Sense - Suppress Null Value of Expression

under complement, uncheck this:

Capture.PNG

parthakk
Contributor II

Re: Qlik Sense - Suppress Null Value of Expression

Hi Omar,

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

Thanks,

Partha K

beck_bakytbek
Honored Contributor

Re: Qlik Sense - Suppress Null Value of Expression

Hi Partha,

how does look your expression?

parthakk
Contributor II

Re: Qlik Sense - Suppress Null Value of Expression

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
Honored Contributor

Re: Qlik Sense - Suppress Null Value of Expression

Hi Partha,

can you show your example? (as expression)