topic Re: Supress Entire Row When Value Is Null in QlikView

Supress Entire Row When Value Is Null

Thu, 24 May 2012 18:48:33 GMT

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.

Re: Supress Entire Row When Value Is Null

john_duffy — Thu, 24 May 2012 19:09:21 GMT

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.

Supress Entire Row When Value Is Null

Sun, 27 May 2012 06:18:04 GMT

Thanks John, it certainly works.

- Khaled.