Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anybody explain me what are the uses cyclic group and drill down group and their difference?
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
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.
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
Check this video
Hi
Just check this link it will be helpfull
Dimension grouping in QlikView - QlikView Blog, QlikView Videos and Tips at QlikShare