topic Re: Supressing null values in QlikView

Supressing null values

Tue, 17 Feb 2015 10:47:48 GMT

Hi Experts,

I am trying to supress the values by using supress when values is option,but not succeed.

I have the data in straight table like below.

The data is same for all the fields except last field.

Now I want to supress the row where Components values as blank.but unable to succeed by using supress when values is option.

Can any one provide any sugesstions how we can supress that values from table???

Order ID	Date	Item	Status	Components
1	12/10/2014	A	Wait
1	12/10/2014	A	Wait	X
1	12/10/2014	A	Wait	Y
1	12/10/2014	A	Wait	Z

Anonymous — Tue, 17 Feb 2015 10:51:15 GMT

did you define "suppress Zero-Values" in the tab presentation as well?

anbu1984 — Tue, 17 Feb 2015 10:51:51 GMT

What are your expressions in this table?

Only when all your expressions are null and "Suppress zero values" is set, then row will be suppressed

anithashivalingappa — Tue, 17 Feb 2015 10:54:14 GMT

Hi Swati,

If components is dimension then you can use "suppress when values is Null".

You can also try in presentation tab "suppress Zero-values" & "Suppress Missing" option.

jonathandienst — Tue, 17 Feb 2015 10:59:38 GMT

It will only suppress the row if all expressions return values that are null or zero. So the expressions should look like this:

=If(Len([Components]) <> 0 And [Components] <> 0, <original expression>)

Which ensures that all the value are null if the Components value is null or zero.

HTH

Jonathan

PrashantSangle — Tue, 17 Feb 2015 11:05:29 GMT

Hi,

Take Component as Dimension and check "Supress When Value is null"

Regards

tobias_klett — Tue, 17 Feb 2015 11:06:09 GMT

Hi,

I guess you field in not NULL but empty.

Therfore enter the following set statement to your expression:

{<Components=-{''}>}

Regards Tobias