topic Re: Null Handling in QlikView

Null Handling

Mon, 08 Jun 2015 13:32:55 GMT

Hi All,

I have a column in excel with some white spaces present in some of the field values.

When I use isnull function, then it considers, white spaces as also not null.

Can we use some function which would also treat only white spaces entered in some of the field values as null?

Thanks,

Asma

giakoum — Mon, 08 Jun 2015 13:33:48 GMT

use isnull together with trim

if(isnull(trim(yourfield....

buzzy996 — Mon, 08 Jun 2015 13:38:28 GMT

may be,tey tis way..

if(count(urfield)>0,urfield,isnull())

sory,use len instituted of count.

sunny_talwar — Mon, 08 Jun 2015 13:38:53 GMT

or you can try this as well

If(Len(Trim(yourField)) <> 0,....

and if you are using it in where clause, then like this:

Where Len(Trim(yourField)) <> 0;

jonathandienst — Mon, 08 Jun 2015 13:45:22 GMT

Check the length, as the length of a null is also 0. So instead of isnull:

if(len(field) > 0, ....)

If the field could contain blanks, then

if(len(trim(field)) > 0, ....)