topic Re: Having issue working with nulls in QlikView

Having issue working with nulls

Fri, 25 Apr 2014 19:38:10 GMT

Hi everyone,

I have imported a field from a SQL database that contains nulls. I would like to assign a name to a new field based off of whether or not my original field is null or contains a value. This seems like a simple problem to solve using this code:

if(IsNull(field), 'string', 'string2') as field2

However, for some reason I'm getting the string2 in field2 for rows that have a null for field. Does anybody have an idea of why this is happening - or have a better way of accomplishing this bit of logic?

Thanks

Re: Having issue working with nulls

Colin-Albert — Fri, 25 Apr 2014 19:56:56 GMT

Try

If(len(trim(field))=0, 'string','string2') as field2

Re: Having issue working with nulls

maxgro — Fri, 25 Apr 2014 20:04:12 GMT

perhaps you haven't a true null but a blank or some other char that seems null

so just use Colin answer

Re: Having issue working with nulls

Fri, 25 Apr 2014 20:05:41 GMT

When QlikView displays "-" in a list does that mean that it is a null?

Re: Having issue working with nulls

Anonymous — Fri, 25 Apr 2014 20:16:32 GMT

Try Alt(field, String) as field2;