Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Where do the two values X and Y originate from? A field? or a calculated dimension / field expression?
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