Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what are the uses cyclic group and drill down group?

can anybody explain me what are the uses cyclic group and drill down group and their difference?

7 Replies
arulsettu
Master III
Master III

ankit777
Specialist
Specialist

engishfaque
Specialist III
Specialist III

Dear Madhu,

Groups

Groups, or more correctly field groups, are collections of fields, which can be used instead of fields as chart

dimensions. There are two types of field groups:

Drill-down groups are used to create hierarchies of fields allowing so called drill-down in charts.

Cyclic groups are non-hierarchical and are normally used just as a convenient way of letting the user switch

chart dimension fields by a simple mouse click.

Ref: QlikView Reference Manual, Page No. 173

Kind regards,

Ishfaque Ahmed

sujeetsingh
Master III
Master III

QlikView charts support  flexible feature called variable groups. Groups are

lists of variables that are defined as cyclic or drill-down. These groups can flow

naturally, e.g., Year, Quarter, Month, Day, or mix any type of variables, e.g., Year,

Customer, Product. When a group is used as the variable specification in a chart, the

chart gains new functionality depending on the type of group used.

Drill-down groups specify variables that display sequentially as you drill-down in the

chart. When only a single value (one bar, one slice, or one point, depending on the

chart type) is available to be displayed in the chart, QlikView automatically drills down

to the next variable level. For example, a bar chart could be displayed showing total

sales for 12 months. When a single month's bar is selected, the chart can automatically

drill down to display sales for the 4 weeks in that month. When a single week is

selected, the sales for the 7 days of the week are displayed. When a single day is

selected, the sales for the individual customers could be displayed.

Alternatively, groups can be defined as cyclic instead of drill-down. When a cyclic

group is specified as the variable in a chart, a cycle button is automatically affixed to the

chart. When the cycle button is pressed, the chart displays the next variable in the

group. Alternatively, the user can right-click on the button to see a list of variables or

expressions in the cycle and move directly to any one. In the example above, the chart

would still start out displaying total sales for 12 months. When the cycle button is

pressed, the chart would change to show the sales for all 52 weeks of the 12 months (or

any months that were selected.) The chart would cycle through each of the variables

with each press of the cycle button.

kushalthakral
Creator III
Creator III

Hi Ankit

Cyclic Group:

when you make Cyclic group as a Group in Qlikview then it means you can switch between different dimensions

like:

if u have Cyclic group of Year , Quarter and month then you can easily swtich from Year wise sales to Month wise Sales etc

Drill Down Group:

in drill down group you can combine different dimensions for the purpose of drill down like Year to month to day wise sales.

Regards

Kushal T

anbu1984
Master III
Master III

Not applicable
Author