topic Cyclic Group in QlikView

Cyclic Group

bharatkishore — Wed, 30 Jan 2013 05:56:41 GMT

Dear Member,

I have a small question regarding cyclic group.

I had created a cyclic group say A-->B-->C and i have two sheets.

I took that cyclic group as a dimension. Now my question is if i click on A it will go to B. And if i click on B it will go to C. Now if i click C it should go to chart which is in other sheet.

C data wil be in other sheet say sheet2. Can you please tell me how to do.

Regards,

RBK

Re: Cyclic Group

Jason_Michaelides — Wed, 30 Jan 2013 06:08:57 GMT

Hi RBK,

For this I think you will need a combination of a variable, GetCurrentField() and a trigger.

Create a variable, vMyGroup, and set the expression to =GetCurrentField("MyGroup") where MyGroup is the cyclic group name.
Create an OnChange Variable Event Trigger (Settings > Document Properties > Triggers). Action = Layout > Activate Sheet. In the Sheet ID expression box put =If(vMyGroup='C','Document\SH02')

Hope this helps,

Jason