Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Requrirement on Multi box

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

2 Replies
swuehl
MVP
MVP

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

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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