Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
sebastian_fager
Not applicable

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?

Tags (2)
3 Replies
sunny_talwar
Not applicable

Re: Add value to NULL

Are they linked or joined together?

sebastian_fager
Not applicable

Re: Add value to NULL

They are linked.

sunny_talwar
Not applicable

Re: Add value to NULL

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