topic Select in field - Multiple Values in QlikView

Select in field - Multiple Values

embruqlikview — Thu, 18 Mar 2021 09:28:08 GMT

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

Re: Select in field - Multiple Values

edwin — Thu, 18 Mar 2021 14:51:18 GMT

pipe instead of comma
(xxxx|xxxx|xxxx)

Re: Select in field - Multiple Values

embruqlikview — Fri, 19 Mar 2021 07:26:33 GMT

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?

Re: Select in field - Multiple Values

edwin — Fri, 19 Mar 2021 13:10:31 GMT

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

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

hope that helps