remove null or blank expression values or rows

[qliklearnervir]

I having 4 fields:

(1) Name

(2) Address 1

(3) Address2

(4) pOSTAL coDE

I dont want to show the rows in the straight table in qlikview having null or blank rows in Address1 or Postal code ...please suggest.

Name and address are coming from different tables.

[Chanty4u]

hi,

chk below

Removing Rows with Nulls

[Anonymous]

under tab Dimension unclick "suppress when value is null"

and under presentation "clikck "suppress Zero values"

that should do it

[#4]

Go to Chart Properties => Choose Presentation Tab => Choose Address1 from the box named Columns and then Check Suppress Missing and Check Suppress Zero-Values.

Does this help you?

[Mahamed_Qlik]

Hi Vir,

If you don't want null values in your application then always it is best practice to remove those null values from script level. You can remove at scripting.

Hope this information helps you.

Regards,

Mahamed.