user shouldnt be able to select the excluded values in list box

[gireesh1216]

Hi Team,

I have a listbox and  based on other listbox selections, this listbox has some excluded values, that are shown in grey when those values are not related.

I want to show all values (possible,excluded), but user shouldnot be able to select the excluded values.

[i.e. when clicked on grey/excluded values, it shouldnot get selected]

can we do that? If yes, How?

Thanks

Gireesh

[marcus_sommer]

Try this one: =aggr(only({1< Field= e(Field) >} Field), Field)

- Marcus

[MarcoWedel]

Hi,

maybe you could lock already selected fields. Selections of excluded values will not be accepted in this case.

Another option might be a trigger/action that reverts back to the previous selection when selecting excluded values (thus undoing selections in other fields)

hope this helps

regards

Marco

[lorenzoconforti]

You should be able to recreate your list box using a straight table; through set analysis you can show excluded values but the selection would not be possible as they would be excluded from your state.

Also, to make it look like a list box, you can colour code the rows using "Backgroud colour" option in Dimensions

[gireesh1216]

This "aggr(only({1< Field= e(Field) >} Field), Field)" expression shows only excluded values.

[marcus_sommer]

Yes, this was the aim for the second listbox which has enabled the read-only mode and your first listbox will display the possible ones. Both together will work like you described - of course there is the disadvantage of having two objects.

Otherwise you will need to look for another workaround maybe in the direction Marco has suggested with actions which lock fields and/or revert any unwanted selections but you won't get it without any costs ... it will also have disadvantages ...

- Marcus