topic Re: Removing the Null Values from the text box in QlikView

Removing the Null Values from the text box

sandeepprasad_j — Mon, 22 Apr 2013 11:45:47 GMT

HI Experts,

The null values are being displayed in the text boxes and i am trying to use the expression below in the Field expression

Think there are associated data with the null values in the other list boxes. Not sure this is affecting the following expression.

if (Len(field) > 0, Field)

But it is not solving my issue .

Can u please help me out in solving this issue .

Thanks,

Sandeep.

Re: Removing the Null Values from the text box

Gysbert_Wassenaar — Mon, 22 Apr 2013 18:15:11 GMT

Your expression returns a null if the length of the field is 0. So in those cases you are not removing nulls. You can replace them with zero-length strings if you want: if(Len(field) > 0, Field,'')

Re: Removing the Null Values from the text box

nilesh_gangurde — Mon, 22 Apr 2013 19:10:20 GMT

Hii Sandeep,

You can use the below mentioned expression:

if(wildmatch(field,'') or len(field) = 0 or isnull(field),null(),field)

or if you want display the null value you can go with:

if(wildmatch(field,'') or len(field) = 0 or isnull(field),'Null',field)

-Nilesh

Re: Removing the Null Values from the text box

sandeepprasad_j — Tue, 23 Apr 2013 06:08:22 GMT

Hi Gysber,

Thanks for the reply but ,the expression u have give is not solving my issue ... Can u please help me out ...Sorry i had said text box .. but it is listbox .

Below is the Screenshot .. and 'Yellow' colour is the Null value being displayed .

Thanks,

Sandeep.

Re: Removing the Null Values from the text box

hic — Tue, 23 Apr 2013 07:11:18 GMT

NULLs are never displayed in a list box. But blanks and empty strings are.

You probably have some white space (blanks, tabs, hard spaces, etc.) so that it is not zero length. Try

If(Len(Trim(Field))>0,Field)

If(Len(Purgechar(Field, chr(32) & chr(160)))>0,Field)

HIC

Re: Removing the Null Values from the text box

sandeepprasad_j — Tue, 23 Apr 2013 07:21:48 GMT

Hi Henric ,

Thanks for the reply .. I was exactly looking in to this ,wat u have mentioned ... thanks a lot

Sandeep.