Null values in tables

[saviostrazzullo]

I linked 2 tables A and B and I need to select rows in A which are not present in B. I can't select  Null values in A and I tryed to insert a function in the field of the object: if (IsNull (field), 'T','F') but it doesn't recognize the Null Value. I also tryed to set null value in the script but it doesn't work.

Thank you

Savio

[#2]

qlikview is not handling nulls properly even i faced the same issue ....when i usedlen(field) it shows 0 but it is not treating as null

len(trim(field))>0 works

u may address this issue

[#3]

qlikview is not handling nulls properly even i faced the same issue ....when i usedlen(field) it shows 0 but it is not treating as null

len(trim(field))>0 works

[#4]

I had the same issue:

The below takes into account all Null values.

see link:

http://community.qlik.com/thread/171354?sr=inbox

SET Nullvalue = '';

NULLASVALUE *;

[OmarBenSalem]

There is a function for such a problem which is : NullAsValue which simply convert the Null into selectable values.

In your script editor do as so :

set NullValue='Missing';

Then above of your load statement enter this :

NULLASVALUE *;

This will replace all the Null Values in your data with the selectable word 'Missing'.

Omar,