How to remove all previous selection on a particular column

[#1]

Dear all,

We have 3 list boxes (3 back-end columns) and we want only 1 selected value across all three columns. User should not be able to select multiple values in any of the list boxes. We have checked the single value selection option in the list box (for all three list box) but doe to this selection we are not able to clear value in other field(list box)

We tried one backed column instead of three columns and based on flag values created 3 list boxes so that selections are automatically cleared in other list boxes. However this approach has a limitation that we cannot have single value selection..

Please let us know any approach to solve this problem ..

[struniger]

Hi Ruchi,

If I understand correctly you want to have only one selected value per three dimensions.

One approach could be to add a field event trigger (Document Properties -> Triggers -> Field Event Triggers), where on selection of Dimension 1 you would clear any selections on dimension 2 and 3.

Not sure if this will work with 'always one selected value' though. But maybe it'll help you on the way.

Best regards

Stefan

[#3]

Hi Stefan,

Thanks for your inputs.

The above approach works fine on the application of the Event Trigger but though the list boxes have 'always one selected value' option checked, it does not suffice the requirement.

Regards,

Ruchi

[#4]

Hi Ruchi,

In attached file only thing you can't do is you can't have pre-selected value for all three lists at the same time

Because we to clear list 1 when we select list 2 so when we try to pre select value in all three lists at document open event it only get selected third list.

Thanks,

Prakash

[#5]

Hi,

=Aggr(Only( {<  FIELD = p(FIELD) >}FIELD),FIELD)

Apply this expression in your listbox.Uncheck the Always one selected.

Hope it helps.

Thanks.

[#6]

Hi gtripathy,

Thanks for your input. The above response is very helpful.

Can you also help us know if we can pick up the dimension name dynamically. So if we have one selected value (i.e. unique) across 3 list boxes, where we would like to have that particular value as a dimension in our chart.

Let us know if you would require any more details.

Regards,

Ruchi

[#7]

Hi Ruchi,

Could you please post a sample app or snapshot for better understanding? There is np at all using the same field as Calculated Dimension in your chart.

Don't hesitate to try something what you feel may work out?

Thanks.

[#8]

Hi gtripathy,

As proposed, we have created a sample app.

Kindly look into the same.

Thanks.