Very basic GetFieldSelections issue for selecting multiple fields

[jjohnstonti618]

I have attached a very simple example of what I am trying to do in a separate much larger file with many more selections.  Basically i want to select YearA, and based on my selection, have YearB automatically selected the same values.  Works fine for 1 year at a time but no luck when i select 2 or more years at a time.  Details in attachment.  Any help or explanation is much appreciated.

Thanks

James

[sunny_talwar · Accepted solution]

Trigger using this

=If(GetSelectedCount(YearA) > 0,  '(' & Concat(DISTINCT '"' & YearA & '"', '|') & ')')

[jjohnstonti618]

That did it.  Thanks Sunny! 

The second I looked at your reply, I assumed the reason the default formula does NOT work in this case because the triggers in qlikview default to the "|" symbol for separating multiple fields?  Either way, this does the trick. Thank you again