topic Variable Event Trigger is not working in Cyclic Group in QlikView

Variable Event Trigger is not working in Cyclic Group

Fri, 26 Sep 2014 14:42:14 GMT

Hi,

I Have 2 Cyclic Groups in my app and they are using in 2 different charts in a sheet, my requirement is when i change first Cyclic group selection then according to that 2nd Cyclic group field selection need to be changed dynamically.

For that created 2 variables Var1=GetCurrentField(CyclicGroup1),Var2 =GetCurrentField(CyclicGroup2)

and then created Variable Event Trigger on change of Var1 add action switch selection in (Var2 ).

But it's not working as expected.

Appreciate some experties help here.

Thanks,

shekar.

Re: Variable Event Trigger is not working in Cyclic Group

tcullinane — Fri, 26 Sep 2014 14:55:25 GMT

how are the groups related? could you use an if statement in the Var2 definition to change it rather than a trigger

ie load the group1 names in inline load in script

use a listbox to make the selection

and group2 name changes based on thatselection

Re: Variable Event Trigger is not working in Cyclic Group

Fri, 26 Sep 2014 14:55:47 GMT

The cyclic group is duplicated or are different?

Re: Variable Event Trigger is not working in Cyclic Group

Fri, 26 Sep 2014 15:04:03 GMT

Hi Ramiro,

The cyclic group fields and hierarchy are same ,but applying some conditions for the feilds.

hope you understood.

Re: Variable Event Trigger is not working in Cyclic Group

Fri, 26 Sep 2014 15:11:03 GMT

Hi Thomas,

Both Cyclic Groups are using the same fileds,but 2nd cyclic group conatins some conditional expressions to restrcit top X Values in Pivot table.

Re: Variable Event Trigger is not working in Cyclic Group

Fri, 26 Sep 2014 17:07:20 GMT

Any Suggestions ?

Re: Variable Event Trigger is not working in Cyclic Group

Fri, 26 Sep 2014 17:31:55 GMT

Hi Shekar,

Can't you try with the same Cyclic group for both the charts and expression conditions at chart level separately??

Re: Variable Event Trigger is not working in Cyclic Group

Fri, 26 Sep 2014 17:45:47 GMT

Hi Kruthi,

I tried that option already,but in the 2nd chart which using 2nd cyclic group to restrict topX values in pivot table.

so in expression unable to restrict,so added it in 2nd cyclic group.