Requrirement on Multi box

[#1]

Hi

,

i have multi box in which have two Values but it is showing three values including Null value

Example:

I have values X,Y

but in my Multi box showing

1)X

2)

3)Y

how to remove that null value

Thanks

[swuehl]

Where do the two values X and Y originate from? A field? or a calculated dimension / field expression?

[stevedark]

For it to show in a multibox it must be an empty string, rather than a null.

The best way to remove it will be in the load script, something like this:

LOAD

    if(rtrim(MyField) = '', null(), MyField) as MyField,

      etc.

Generally though, it is better to have a value attached, so that you can select it - nulls can not be selected.  You can implement that like this:

LOAD

    if(rtrim(MyField) = '', '- Missing -', MyField) as MyField,

    etc.

Hope that helps,

Steve