topic Trigger: Getmyfieldselections. Multiple selections. in QlikView

Trigger: Getmyfieldselections. Multiple selections.

Tue, 01 Sep 2015 10:58:36 GMT

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

Re: Trigger: Getmyfieldselections. Multiple selections.

sunny_talwar — Tue, 01 Sep 2015 11:00:15 GMT

Try this:

Field CalendarBMonth

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

Field CalendarBMonth

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

Re: Trigger: Getmyfieldselections. Multiple selections.

Tue, 01 Sep 2015 11:03:08 GMT

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?

Re: Trigger: Getmyfieldselections. Multiple selections.

sunny_talwar — Tue, 01 Sep 2015 11:06:57 GMT

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