1 Reply Latest reply: Jul 10, 2012 11:56 PM by Johannes Sunden RSS

    How to force select one according to another listbox selection.

      Hi all,

       

      I am going to force the number selections in some listbox based on another listbox. the sample data are as below:

       

      I got 3 listbox

       

      listbox A

      Junior

      Senior

      Director

       

      ListBox B

      Factory

      Shop

      BackOffice

       

      Listbox C

      A

      B

       

      I want to do the following:

       

      If i select 'A' listbox C, then I can select anything in listbox A but just can select 1 object in listbox B.

      If i select 'B' listbox C, then I can select anything in listbox B but just can select 1 object in listbox A.

       

      Can anyone provide me some suggestion how can I set the listbox?

       

      Thanks.

       

      Best Regards,

      Nick

        • Re: How to force select one according to another listbox selection.
          Johannes Sunden

          Hi,

           

          You could potentially control this with a macro where you set an initial selection based on the change in listbox C and toggle the "Always one selected value" checkbox for Listbox A/B depending on the selection in C.

          However, this is pretty cumbersome and not very intuitive for the people using the application.

          I would recommend leaving the selections free and then use calculation conditions on the visualizations that you want to do based on the selections so that if you've selected more than one value in both A and B the chart will not calculate and display a helpful message for the required selection base.