topic Group Triggers? in QlikView

Group Triggers?

Thu, 29 Jul 2010 20:08:09 GMT

I have two cyclic groups and want to keep them in sync with regards to which one of the group items is selected. Is there any way to do this?

For example, group #1 has calculated dimensions for months and years. Group #2 has calculated dimensions, which are different from Group #1, also for months and years. When I change group #1 to months from years I want to also have Group #2 change from months to years.

Group Triggers?

wizardo — Fri, 30 Jul 2010 08:45:28 GMT

sorry for only giving partial reply, but maybe someone can take it from here.

it is possible to get the active field in one group and then to cycle the other a group via automation

take a look at these API samples:

for getting the active field:

groups=ActiveDocument.GetGroups
set fld = groups(0).GetActiveField

for moving the cycle one step:

groups=ActiveDocument.GetGroups
groups(0).Cycle 1

but....... i still cannot figure out a way to trigger these automation calls when ever the user cycles a group

Mansyno

Group Triggers?

jonathandienst — Fri, 30 Jul 2010 09:20:45 GMT

Give this a try:

create a variable (say vCyclic1) defined as =GetCurrentField(CyclicGroup1)
Use the OnChange variable event trigger on vCyclic1 to fire the macro

Haven't tested this, so let us know whether this works

Jonathan