Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sebastian_fager
Contributor III
Contributor III

Add value to NULL

Hi,

I have two tables that are linked by one key and i want to add a value to null's..

I have tired:

   if (isnull([field]) or field='',1,0) as test2,

   if(len(trim(field))=0,'0','field') as test,

   istext(field) as test3,

   isnum(field) as test4,

i have also tried:

    SET NullValue='Missing';

   NullAsValue *;

Screenshot 2016-12-09 15.22.27.png

But it dosen't work. What els could i try?

3 Replies
sunny_talwar

Are they linked or joined together?

sebastian_fager
Contributor III
Contributor III
Author

They are linked.

sunny_talwar

So may be they are not null and they are just missing. Look here to see the difference between null and missing

NULL handling in QlikView