topic Always One Selected Value on 2 dependent field in QlikView

Always One Selected Value on 2 dependent field

Mon, 10 Feb 2014 03:33:54 GMT

Hello,

I have the following table

I need to enable the property [Always One Selected Value] on both field, but it stops me to switch from one [Conversion] to another.

Please check the attached sample.

Re: Always One Selected Value on 2 dependent field

chiru_thota — Mon, 10 Feb 2014 04:55:18 GMT

Hi,

Try a different approach here instead of enabling Always one selected in multi box itself.

apart from two multi boxes create list boxes for your individual columns and enable always one selected property.

Hide the extra list boxes created.It should work.

Have a look at attached QVW.

Thanks,

Chiru.

Re: Always One Selected Value on 2 dependent field

Mon, 10 Feb 2014 06:56:03 GMT

Hi Chiranjeevi,

It does not work, as I need to unselect the Year to be able to change the Conversion and if I add the attribute [Always One Selected Value] to the listbox Year, then the switch of Conversion become totally impossible. User should not be able to select multiple years.

Re: Always One Selected Value on 2 dependent field

jonathandienst — Mon, 10 Feb 2014 07:03:33 GMT

With Always One Selected on the Year field, you will not be able to select 'Variable' in your above example because that implies a null Year (which means nothing selected). So what you are attempting does not work.

Can you not use some other technique to make your user select a year, such as conditional calculation or conditional visibility of the charts?

HTH

Jonathan

Re: Always One Selected Value on 2 dependent field

jonathandienst — Mon, 10 Feb 2014 07:06:01 GMT

Note that the always one selected property applies to the field, even though you set it in a list box or multibox. So any other list boxes for that that field will have the same setting.

Re: Always One Selected Value on 2 dependent field

Mon, 10 Feb 2014 07:15:31 GMT

The Conversion = Variable is only available for NA# year. So when you are selection 2010, then Conversion = Constant. And You would not be able to select Conversion=Variable since it is now a excluded value.