Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Creator III
Partner - Creator III

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.

View solution in original post

2 Replies
john_duffy
Partner - Creator III
Partner - Creator III

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
Author

Thanks John, it certainly works.

- Khaled.