topic Cyclic Group in Dimension in QlikView https://community.qlik.com/t5/QlikView/Cyclic-Group-in-Dimension/m-p/248335#M1186197 <HTML><HEAD></HEAD><BODY><P> Actually I found the solution:</P><P></P><P>groups=ActiveDocument.GetGroups</P><P>groups(0).Cycle 1</P><P></P><P>(Group number is an ordinal number in your groupg collection and Cycle 'n' is the ordinal number of fileds in the group.</P><P>REmeber that the numbering is zero based)</P></BODY></HTML> Fri, 09 Sep 2011 00:05:01 GMT jduenyas 2011-09-09T00:05:01Z Cyclic Group in Dimension https://community.qlik.com/t5/QlikView/Cyclic-Group-in-Dimension/m-p/248334#M1186196 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I have a chart with a cyclic group as a dimension. The cyclic group consists of 4 fields, A, B, C, D.</P><P>I also have a report that contains the chart.</P><P></P><P>For an automation process that will print the report I created a script in VB which selects some fields (Year, Month, Sales Reps) prior to printing and I wish to select one of the cyclic fields (example 'C') so the chart shows the correct view.</P><P></P><P>Can that be done via VB code?</P><P></P><P>Any help is appreciated</P><P></P><P>Thanks</P><P></P><P>Josh</P></BODY></HTML> Thu, 08 Sep 2011 23:31:39 GMT https://community.qlik.com/t5/QlikView/Cyclic-Group-in-Dimension/m-p/248334#M1186196 jduenyas 2011-09-08T23:31:39Z Cyclic Group in Dimension https://community.qlik.com/t5/QlikView/Cyclic-Group-in-Dimension/m-p/248335#M1186197 <HTML><HEAD></HEAD><BODY><P> Actually I found the solution:</P><P></P><P>groups=ActiveDocument.GetGroups</P><P>groups(0).Cycle 1</P><P></P><P>(Group number is an ordinal number in your groupg collection and Cycle 'n' is the ordinal number of fileds in the group.</P><P>REmeber that the numbering is zero based)</P></BODY></HTML> Fri, 09 Sep 2011 00:05:01 GMT https://community.qlik.com/t5/QlikView/Cyclic-Group-in-Dimension/m-p/248335#M1186197 jduenyas 2011-09-09T00:05:01Z