Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
...
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.
Hi,
Please see if the attached sample can help you.
Cheers.
"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?
Hi,
Multiple ways to do this, may be this will help you.
Cheers.
Thanks BlackRockS, that looks much better and it's very simple.
Hi,
Good it helped you.
Cheers.