Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

Cyclic Group in Dimension

Hi all

I have a chart with a cyclic group as a dimension. The cyclic group consists of 4 fields, A, B, C, D.

I also have a report that contains the chart.

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.

Can that be done via VB code?

Any help is appreciated

Thanks

Josh

1 Reply
jduenyas
Specialist
Specialist
Author

Actually I found the solution:

groups=ActiveDocument.GetGroups

groups(0).Cycle 1

(Group number is an ordinal number in your groupg collection and Cycle 'n' is the ordinal number of fileds in the group.

REmeber that the numbering is zero based)