topic Re: Null values in List Box in QlikView

Null values in List Box

Anonymous — Fri, 23 May 2014 06:34:29 GMT

Hello All.

I am having some null values in my list box.

Could some body help to remove those null values from list box?

Regards,

Balraj Ahlawat

Re: Null values in List Box

hic — Fri, 23 May 2014 06:38:16 GMT

NULL values are never shown in list boxes. Instead, what you probably have is empty strings, or strings with blanks. I would convert these to NULLs in the script by using

If(Len(Trim(MyField))>0,MyField) as MyField

Then they will not show up in the list box.

HIC

Re: Null values in List Box

tresB — Fri, 23 May 2014 06:39:01 GMT

Try expression, like: If(len(Trim(YourField))>0, YourField)

Re: Null values in List Box

SunilChauhan — Fri, 23 May 2014 06:42:33 GMT

if( fieldname<>' ',Fieldname)

if(len(fieldname)>0,Fieldname) /// as henric suggeted

if(fieldname=null(),fieldName)

or if there is some null characters like .,-

then

you can use

if(fieldname<>'.',fieldname)

if(fieldname<>'-',fieldname)

hope one of them work for you

Re: Null values in List Box

Anonymous — Fri, 23 May 2014 06:52:21 GMT

Agreed Henric,

Its not null values, It is empty strings.

Let me try out with this expression.

Regards,

Balraj Ahlawat

Re: Null values in List Box

Anonymous — Fri, 23 May 2014 06:57:54 GMT

Thanks.

Its done.

Regards,

Balraj Ahlawat