topic Multibox question in QlikView

Multibox question

tduarte — Tue, 26 Jul 2011 16:32:06 GMT

Hi,

I have a Multibox with a Country infomation and Always One Value Selected.

Is there a way of adding an extra value "All Countries" that would appear on the list and would either mean all countries selected or no selection on country?

So on the open multibox you'd have:

All Contries

UK,

Germany,

France,

...

Multibox question

swuehl — Tue, 26 Jul 2011 17:05:23 GMT

Hi,

you could probably add an "All Countries" to the list, but as far as I know not from within the box.

I am just thinking of kind of a linkage table betwenn your dimension values used for the list box and the country dimension used in calculations. Maybe I just miss a much easier solution right now.

And if you add "All Countries", you could also add "No Countries" (with no links in linkage table). That would be consistent with the usage model.

Stefan

P.S. How have you managed to use Always One Value Selected in a Multi box? Haven't found that option so far.

Re: Multibox question

Wed, 27 Jul 2011 03:22:56 GMT

Hi,

Please see if the attached sample can help you.

Cheers.

Multibox question

tduarte — Wed, 27 Jul 2011 09:08:24 GMT

"P.S. How have you managed to use Always One Value Selected in a Multi box? Haven't found that option so far."

swuehl, on QV10 just select on value on the field of the multibox and then go to the Presentation tab and tick Always One Selected Value.

Thanks BlackRocks, your solution would work but it means duplicating my main facts table.

Is there another way of doing this with a variable and an expression on the multibox for example? Maybe with set analysis too?

Re: Multibox question

Wed, 27 Jul 2011 09:35:58 GMT

Hi,

Multiple ways to do this, may be this will help you.

Cheers.

Multibox question

tduarte — Wed, 27 Jul 2011 09:49:32 GMT

Thanks BlackRockS, that looks much better and it's very simple.

Re: Multibox question

Wed, 27 Jul 2011 09:51:50 GMT

Hi,

Good it helped you.

Cheers.