topic Re: Changing null in QlikView

Changing null

Mon, 11 Jun 2012 18:44:10 GMT

Hey,

How do I go about changing Null values in my table to zero or 1?

Thanks!

Changing null

Anonymous — Mon, 11 Jun 2012 19:34:05 GMT

If you mean a database table, you can use the statement:
set NullDisplay='0';
in your script to replace all NULL values with 0.

If you mean in a pivot or straight table, you can set the Null Symbol value on the Presentation tab of the Properties dialog.

-Phil

Changing null

Mon, 11 Jun 2012 19:49:35 GMT

Is there a way to specify it to one column in a table and not the others?

Changing null

MayilVahanan — Mon, 11 Jun 2012 21:38:07 GMT

Hi,

Try this ,

=if(Columnname = '' , 1, Columnname)

Hope it helps

Changing null

Anonymous — Mon, 11 Jun 2012 22:38:00 GMT

If it is a database load, you may have to use:
If(isnull(Columnname),1,Columnname) as Columnname

-Phil

Re: Changing null

Sokkorn — Tue, 12 Jun 2012 04:20:09 GMT

Hi,

This one would work

IF(IsNull(Field) OR Len(Field)>0,0,Field)

Hope this help.

Regards,

Sokkorn

Re: Changing null

Tue, 12 Jun 2012 04:41:58 GMT

hi,

If you want to do it in backend then ,

before the starting of the script you need to write:

to set null value as 1

NULLASVALUE *;

SET NullValue =1;

Similarly you can do to set null values as 0.

I Hope this will solve your purpose.

Pratibha

Re: Changing null

Tue, 12 Jun 2012 13:24:30 GMT

It loads but does not change because the NULL values that I have are in that column but in a different table. I went to the presentation tab on the table box and could not find the options.

I have three options in the column on the new table. No, Yes, and NULL.

I need to change the No to a 1, the Yes to a 0, and the NULL to a 0.

The No and Yes are in the original load, the NULL happens when I put this column into a different table after its loaded in. The new table is a table box.

Re: Changing null

Tue, 12 Jun 2012 13:25:03 GMT

It loads but does not change because the NULL values that I have are in that column but in a different table. I went to the presentation tab on the table box and could not find the options.

I have three options in the column on the new table. No, Yes, and NULL.

I need to change the No to a 1, the Yes to a 0, and the NULL to a 0.

The No and Yes are in the original load, the NULL happens when I put this column into a different table after its loaded in and compared to my key. The new table is a table box.