Trigger: Getmyfieldselections. Multiple selections.

[#1]

Hi guys,

Ive created a trigger that gets field selections from Calendar A, which then should select the same range in Calendar B.

It works fine as long as I select only one value. But on multiple it does not work. This is how my trigger looks like:

Field CalendarBMonth

On select: =GetFieldSelections(CalendarAMonth)

Field CalendarBMonth

On Change: =GetFieldSelections(CalendarAMonth)

i.e. when I select/deselect the month January, it works fine. Now when I select January AND Febuary it doesnt do anything. Any tips?

Thank you

[sunny_talwar · Accepted solution]

Try this:

Field CalendarBMonth

On select: ='(' & GetFieldSelections(CalendarAMonth, '|') & ')'

Field CalendarBMonth

On Change: ='(' & GetFieldSelections(CalendarAMonth, '|') & ')'

[#3]

Awesome, thanks alot! Could you explain the operation of the expression so that I can come up with these kind of solutions myself next time I encounter such a thing?

[sunny_talwar]

From QlikView Help:

So in order to get this format (A|B), I added '(' and ')'. and GetFieldSelections by default give values like this -> A, B, but to get A|B I specified the separator to be | -> GetFieldSelections(FieldName, '|')

I hope this helps.

Best,

Sunny