topic Re: remove null or blank expression values or rows in QlikView

remove null or blank expression values or rows

qliklearnervir — Mon, 25 Jan 2016 12:10:33 GMT

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.

Re: remove null or blank expression values or rows

Chanty4u — Mon, 25 Jan 2016 12:14:08 GMT

hi,

chk below

Removing Rows with Nulls

Re: remove null or blank expression values or rows

Anonymous — Mon, 25 Jan 2016 12:15:30 GMT

under tab Dimension unclick "suppress when value is null"

and under presentation "clikck "suppress Zero values"

that should do it

Re: remove null or blank expression values or rows

Mon, 25 Jan 2016 12:22:32 GMT

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?

Re: remove null or blank expression values or rows

Mahamed_Qlik — Mon, 25 Jan 2016 13:26:10 GMT

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.