topic Very basic GetFieldSelections issue for selecting multiple fields in QlikView

Very basic GetFieldSelections issue for selecting multiple fields

jjohnstonti618 — Thu, 01 Mar 2018 20:08:26 GMT

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

Re: Very basic GetFieldSelections issue for selecting multiple fields

sunny_talwar — Thu, 01 Mar 2018 20:12:58 GMT

Trigger using this

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

Re: Very basic GetFieldSelections issue for selecting multiple fields

jjohnstonti618 — Thu, 01 Mar 2018 20:18:52 GMT

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