Skip to main content

Hierarchic groups (drill-down)

When several fields form a natural hierarchy, it makes sense to create a drill-down group. Typical examples of hierarchic groups are:

Time: Year, Quarter, Month

or:

Geography: Continent, Country, State, City

When a drill-down group is used as a dimension in a chart, the chart will use the first fields in the group's list of fields that has more than one possible value. If selections are made that cause the field to have only one possible value, the next field in the list will be used instead, provided that it has more than one possible value. If no field in the list has more than one possible value, the last field will be used anyway.

In the first example above, Year will be used as chart dimension until a single year is selected. The chart will then show Quarter. If a single quarter is selected, the chart will switch to Month.

As selections disappear, so that more than one field becomes available in the upper fields of the group's field list, the chart will automatically be drilled back up. Forced drill-up can be achieved by clicking on the drill-up icon in the chart.

A special feature appears when the same drill-down group is used in more than one dimension in the chart specification. The second time the group occurs, the field used will automatically be taken from one step down the group's field list. For example, if you create a two-dimensional chart with the group Geography above used as both Main dimension and 2nd dimension, Continent and Country will initially be used. As soon as one single continent is selected, Country and State will be used instead.

Information noteAlthough it is convenient to use this feature with natural hierarchies, there is nothing preventing its use in other situations as well.
Information noteIf you use a dimension expression that results in a data island it is not possible to drill down, as a valid hierarchy is required. In this case you need to adapt the expression to incorporate the values in the hierarchy.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com