topic Re: How to show null values as zero? in QlikView

How to show null values as zero?

Mon, 22 Dec 2014 07:25:07 GMT

How to show null values as zero by script?

Ex: If COMM=NULL then 0 else COMM

Re: How to show null values as zero?

sushil353 — Mon, 22 Dec 2014 07:27:17 GMT

Hi,

Try:

if(isnull(Comm),0,comm) as fieldname

HTH

Sushil

Re: How to show null values as zero?

vivek_niti — Mon, 22 Dec 2014 07:29:42 GMT

Hi,

Try this code

If(IsNull(COMM),0,COMM)

Regards,

Vivek

Re: How to show null values as zero?

its_anandrjs — Mon, 22 Dec 2014 07:31:55 GMT

Hi,

You can try with

Load
If(Len(Trim(COMM))=0,0,COMM) as CommField
FRom Source;

And also

Load
If( Isnull(COMM)=-1,0,COMM) as CommField
FRom Source;

Regards

Anand

Re: How to show null values as zero?

lironbaram — Mon, 22 Dec 2014 07:38:58 GMT

you can also use

this command

NullAsValue COMM;

Set NullValue =0 ;

your table load

and then

NullAsNull

Re: How to show null values as zero?

Mon, 22 Dec 2014 07:39:32 GMT

Not working any of the code.

Re: How to show null values as zero?

sushil353 — Mon, 22 Dec 2014 07:44:00 GMT

Hi,

Have u tried:

IF(COMM = 'NULL',0,COMM) as FieldName

HTH

Sushil

Re: How to show null values as zero?

Mon, 22 Dec 2014 07:45:22 GMT

Thank you all.

Re: How to show null values as zero?

engishfaque — Mon, 22 Dec 2014 07:48:54 GMT

Dear JJR,

Convert null values to 0 using simple expression,

=Alt(FieldName, '',0)

Kind regards,

Ishfaque Ahmed

Re: How to show null values as zero?

its_anandrjs — Mon, 22 Dec 2014 07:49:57 GMT

Hi,

It seems you have to convert 0 to NULL if so assume this example

New:
LOAD COMM,ID,If(Trim(COMM)=0,'NULL',COMM) AS FilterField;
LOAD * Inline [
COMM,ID
NULL,1
NULL,2
NULL,3
0,4
300,5
500,7
1400,7  ];

Regards

Anand

Re: How to show null values as zero?

Mon, 22 Dec 2014 07:52:49 GMT

Dear JJR,

Convert null values to 0 using simple expression,

=Alt(FieldName, '',0)

Kind regards,

Ishfaque Ahmed

Thank you Ishfaque Ahmed. It is also working fine.

Re: How to show null values as zero?

kumarravi — Wed, 23 Mar 2022 17:23:26 GMT

Hey mostly I have seen isnull() function is being used in this:

Example:

If(IsNull(Col_name),0,col_name)