Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Field CalendarBMonth
On select: ='(' & GetFieldSelections(CalendarAMonth, '|') & ')'
Field CalendarBMonth
On Change: ='(' & GetFieldSelections(CalendarAMonth, '|') & ')'
Try this:
Field CalendarBMonth
On select: ='(' & GetFieldSelections(CalendarAMonth, '|') & ')'
Field CalendarBMonth
On Change: ='(' & GetFieldSelections(CalendarAMonth, '|') & ')'
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?
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