How to force select one according to another listbox selection.

[#1]

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

[Anonymous]

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.