Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Supress Entire Row When Value Is Null

Dear Community,

How can I suppress the entire row when any value in a given record is null?

I want to show only those records in the straight table where a record does not have any null value in any column

[Pls. find sample attached file]

Thanks,

-Khaled.

1 Solution

Accepted Solutions
john_duffy
Contributor III

Re: Supress Entire Row When Value Is Null

Hi Khaled.

One method is to add a condition to all expressions to check for values that will cause at least one expression to have a null value.

In your application, I added a 'Not Fnd' indicator which is set to 'Y' if any field's length < 1.  I then applied this indicator on all expressions.  I also set the Suppress Zero Values indicator in the Presentation tab.

See the attached application.

Hope this helps,

John.

2 Replies
john_duffy
Contributor III

Re: Supress Entire Row When Value Is Null

Hi Khaled.

One method is to add a condition to all expressions to check for values that will cause at least one expression to have a null value.

In your application, I added a 'Not Fnd' indicator which is set to 'Y' if any field's length < 1.  I then applied this indicator on all expressions.  I also set the Suppress Zero Values indicator in the Presentation tab.

See the attached application.

Hope this helps,

John.

Not applicable

Supress Entire Row When Value Is Null

Thanks John, it certainly works.

- Khaled.

Community Browser