Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER 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
MVP
MVP

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

MVP & Luminary
MVP & Luminary

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