topic Listboxes should be switches in dependence in QlikView

Listboxes should be switches in dependence

Anonymous — Wed, 25 Feb 2015 08:22:33 GMT

Hello,

two listboxen should be switched in dependence. If “Year” is selected, “FiscalYear” must be deselected. If “FiscalYear” is selected, “Year” must be not selected. Thanks for help.

Regards Stefan

Re: Listboxes should be switches in dependence

datanibbler — Wed, 25 Feb 2015 08:25:14 GMT

Hi Stefan,

try with some sheet-level triggers - add an action on both the fields [Year] and [FiscalYear], to clear any selections on the other field respectively.

HTH

Best regards,

DataNibbler

Re: Listboxes should be switches in dependence

morganaaron — Wed, 25 Feb 2015 08:32:06 GMT

Hi Stefan,

As DataNibbler said, you want to set Field Event triggers on both fields, so "OnSelect" you'll add an action to clear the opposing field. This can be found in the Settings > Document Properties then Triggers tab.

Example attached.

Re: Listboxes should be switches in dependence

Anonymous — Wed, 25 Feb 2015 08:48:08 GMT

Many thanks to DataNibbler and Aaron. Boxes works fine.

Stefan