topic Re: How to replace a null value ? in QlikView

How to replace a null value ?

Fri, 07 Nov 2014 10:32:40 GMT

Hey everyone,

When I load a table, there are some null values in a field. I use this field to perform a join. I would like to replace the null values by a string "Unknown" because otherwise I get some trouble with my join.

I have tried :

if( isnull(fieldA), 'Unknown', fieldA ) as FIELD_A,

but it doesn't do what I want.

Any idea ?

Thanks for your help

Re: How to replace a null value ?

Anonymous — Fri, 07 Nov 2014 10:34:24 GMT

if ( not len(fieldA) > 0, 'Unknown', fieldA ) as FIELD_A,

Re: How to replace a null value ?

senpradip007 — Fri, 07 Nov 2014 10:36:34 GMT

Try like:

if(len(fieldA)=0, 'Unknown', fieldA) as Field_A

Re: How to replace a null value ?

MK_QSL — Fri, 07 Nov 2014 10:37:33 GMT

If(IsNull(fieldA) or Len(Trim(Replace(fieldA,'-','')))=0, 'Unknown',fieldA) as fieldA