Solved: how to remove null in my listbox? - Qlik Community

Report Inappropriate Content · ‎2014-12-20

i have like

monthnum:

05

06

07

08

09

before 05 i have null how to remove this ?

jagan · ‎2014-12-20

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.

View solution in original post

its_anandrjs · ‎2014-12-20

Hi,

In the list box expression write

If(Len(monthnum) > 0 , monthnum )

For remove null values.

Regards

Anand

Report Inappropriate Content · ‎2014-12-20

did not worked this

alkesh_sharma · ‎2014-12-20

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.

its_anandrjs · ‎2014-12-20

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

Anonymous · ‎2014-12-20

.... so try

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

MK_QSL · ‎2014-12-20

Try below to create a List box field...

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

rustyfishbones · ‎2014-12-20

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

its_anandrjs · ‎2014-12-20

Then try this ways

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

Regards

Anand

Report Inappropriate Content · ‎2014-12-20

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

where not isNULL(monthnum)

pls try this one