topic Always selected one value in Multi Box in QlikView

Always selected one value in Multi Box

tamilarasu — Fri, 02 Oct 2015 06:33:47 GMT

Hello All,

I am using a external file to load my dimensions into an application. I'm using a variable to display all the dimensions in multi box. And I wish to use always one selected value option in presentation tab. But the variable is not displayed in fields property. See below.

Any one help me sort out this issue.?

Re: Always selected one value in Multi Box

pokassov — Fri, 02 Oct 2015 10:02:08 GMT

Hi!

You can

1. add "list box. "

2. select 1 value

3. check "Always One Selected Value"

4. hide "list box"

then you can use - Closed Multi Box - as "One Selected Value".

I would search for trigger and/or macros to do above steps on changing variable with choosing field

Re: Always selected one value in Multi Box

rubenmarin — Fri, 02 Oct 2015 10:16:23 GMT

Hi Tamil, you don't make selections on a variable, you can assign a value to a variable, only one value, it can be a concatenation of different strings but at the end it's only one value inside the variable, and you can't select it.

You can use a variable that returns a field name, and the multiblox will expand the values of that field, the selections made in that variable-expression will work on the field but still you can't assign the 'one value selected' property to the expression even if the relationship is one to one (one variable-one field).

Re: Always selected one value in Multi Box

tamilarasu — Fri, 02 Oct 2015 10:49:10 GMT

Ruben,

Thank you for the explanation. I thought, I was doing something wrong in variable assigning . Have a nice evening and weekend!!.

Re: Always selected one value in Multi Box

tamilarasu — Mon, 05 Oct 2015 07:52:16 GMT

Hi Sergey,

Seems not working for the variables. If we have dimensions, then above solution working fine. Variables are not displayed in fields property (see above picture). Anyways Thanks for reply.