Jump to content

How to limit list values based on another multiple list selection.

Francesco Guagliardo

Recommended Posts

I have a multiple selectionlist (list1) populated with unique entities from a column [A]. I would like that when selecting one ore more entities in that listanother list (list2) showsthe elemets of column limited by that selection in the first list.

So far I have created a new calculated column [calB] using the followig expression: (this column will be assigned to list2)

If("${list1}"=[A],, Null)This unfortunately does not work when selecting multiple elemets in list1 as [calB] will be an empty column.

Another property of [calB] that I'd like to have is that when (none) is selected in list1, [calB]=. Using the above expression if (none) is selected then [calB] is empty.

I wanted to try some case when then statements like:


when "${list1}"= "(none)" then

else If("${list1}"=[A],, Null)But I get a syntax error. And I not even sure it would work like this.

I hope I have been clear.

Thank you.


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...