Select in field - Multiple Values

[embruqlikview]

I use two time axis, when i select a year, a month, a week, then my app should select the correct item in the second time axis (XZ1_year, XZ1_month, etc.)

This works fine, when the user selects one value, but not, when more than one value was selected.

The function "GetFieldSelections(year)" returns all selected values (2020,2021) but the action "select in field" does nothing.

How can i use this trigger, using multiple values?

Thanks

Rolf

[edwin]

 pipe instead of comma
(xxxx|xxxx|xxxx)

[embruqlikview]

I added the separator in GetFieldSelections()

=GetFieldSelections(Jahr,'|')

But it does not work, when selecting multiples values....

In a text field, i'm getting the values, separated through pipe:

Is something missing?

[edwin · Accepted solution]

to clarify, the format you should use is :  (xxxx|xxxx|xxxx)

one way to arrive at this is ='(' & concat(distinct Jahr,'|') & ')'

hope that helps