how to remove null in my listbox?

[#1]

i have like

monthnum:

05

06

07

08

09

before 05 i have null how to remove this ?

[jagan · Accepted solution]

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.

[MarcoWedel]

Hi,

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

thanks

regards

Marco