Skip to main content

Reviewing your hierarchies

Next, you will review the hierarchies in your logical model. Hierarchies is an optional business logic feature. It defines drill-down relationships between groups.

When you enable business logic, some hierarchies may be automatically created by Qlik Sense from your data model. If you navigate to Hierarchies, you can see that business logic has created two hierarchies.

Hierarchies in the logical model

Default hierarchies in the logical model. There is one for Categories and Products and one for Supplies and Products

Hierarchies indicate groups that can be used to break each other down in analysis. For example, the two hierarchies created by Qlik Sense correctly identify two drill-down relationships in our logical model:

  • The data in the Category fields can be broken down into the data in the Products fields.

  • The data in the Suppliers fields can be broken down into the data in the Products fields.

If you navigate to Sheet, click Insight Advisor, and select CategoryName, Insight Advisor includes a treemap that breaks down CategoryName by ProductName.

Category and products breakdown

Insight Advisor results. A breakdown chart for CategoryName and ProductName is selected.
Tip noteHierarchies do not enable drill-down selections in the generated charts. That requires drill-down dimension master items. For example, if you want map charts that drill-down from to cities after a country is selected, you need to create a corresponding drill-down dimension master item.

In addition to defined hierarchies, the logical model can contain learned hierarchies. These are learned automatically from how fields are used and defined in the data model. For example, navigate to Sheet and click Insight Advisor. From the assets panel, select Country. You now have results that reflect a City-Country hierarchy, including a treemap that shows sum(Sales) by Country and City. This hierarchy is a learned hierarchy detected from the data model.

New Insight Advisor results for Country

Insight Advisor results for selecting Country. There is a breakdown chart selected for Sum of Sales by Country and City

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!