topic Re: how to remove null in my listbox? in QlikView

how to remove null in my listbox?

Sat, 20 Dec 2014 07:56:44 GMT

i have like

monthnum:

before 05 i have null how to remove this ?

Re: how to remove null in my listbox?

its_anandrjs — Sat, 20 Dec 2014 08:03:39 GMT

Hi,

In the list box expression write

If(Len(monthnum) > 0 , monthnum )

For remove null values.

Regards

Anand

Re: how to remove null in my listbox?

Sat, 20 Dec 2014 08:18:25 GMT

did not worked this

Re: how to remove null in my listbox?

alkesh_sharma — Sat, 20 Dec 2014 08:19:12 GMT

Null values do not appear in list box. If you are seeing a blank, its probably because there would be Space which has its own ASCII value.

You need to remove it from the DB.

Re: how to remove null in my listbox?

its_anandrjs — Sat, 20 Dec 2014 08:23:26 GMT

Hi,

I believe in list box you get unique values with at least minimum frequency is 1 and if you get any null values or blank space may be it is due to some symbols in the table. Check those data in the table otherwise do this in the load script.

Regards

Anand

Re: how to remove null in my listbox?

Anonymous — Sat, 20 Dec 2014 08:56:02 GMT

.... so try

If(Len(trim(monthnum)) > 0 , monthnum )

Re: how to remove null in my listbox?

MK_QSL — Sat, 20 Dec 2014 10:44:32 GMT

Try below to create a List box field...

=IF(NOT IsNull(monthnum) or Len(Trim(monthnum))>0,monthnum)

Re: how to remove null in my listbox?

rustyfishbones — Sat, 20 Dec 2014 11:13:44 GMT

IF(LEN(TRIM(monthnum)) >0 , monthnum)

Re: how to remove null in my listbox?

its_anandrjs — Sat, 20 Dec 2014 11:16:48 GMT

Then try this ways

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

Regards

Anand

Re: how to remove null in my listbox?

Sat, 20 Dec 2014 12:08:20 GMT

goto edit script ,after loading the tablefile ,before semicollen symbol use where condition

where not isNULL(monthnum)

pls try this one

Re: how to remove null in my listbox?

jagan — Sat, 20 Dec 2014 12:25:26 GMT

HI Manoj,

Null is supressed in List box I think it is empty spaces, use Trim() to remove blank spaces.

Try like this in script

Load

If(Len( Trim (monthnum) ) > 0 , monthnum ) AS MonthNumWONull

FROM DataSource;

Or in front end give calculated dimension

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

Hope this helps you.

Regards,

Jagan.

Re: how to remove null in my listbox?

MarcoWedel — Sat, 20 Dec 2014 13:08:32 GMT

Hi,

can you post sample app with only the monthnum field loaded?

thanks

regards

Marco