topic Re: Requrirement on Multi box in QlikView

Requrirement on Multi box

Wed, 25 Nov 2020 16:16:04 GMT

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

3)Y

how to remove that null value

Thanks

swuehl — Tue, 14 Jun 2016 21:37:36 GMT

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

stevedark — Tue, 14 Jun 2016 22:42:39 GMT

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