Decomposition Tree Extension for Qlik Sense

Chart Types

Decomposition Tree Extension for Qlik provides the following chart types:

• Decomposition Tree

This section explains how to create and configure Decomposition Tree chart.

Other chart types are available via AnyChart Extensions and AnyGantt Extensions.

Downloading and Installing

Qlik Sense Desktop

To install Decomposition Tree Extension in Qlik Sense Desktop, do the following:

1. Download Decomposition Tree Extension for Qlik Sense.
2. Extract the archive.
3. Open a Windows Explorer window and navigate to the Qlik Sense Extensions directory:
   ..\Users\<UserName>\Documents\Qlik\Sense\Extensions.
4. Copy the anychart-4x-decomposition-tree folder to the Extensions directory.
5. Relaunch Qlik Sense Desktop.

Qlik Sense Server

To install Decomposition Tree Extension on a Qlik Sense server,

1. Download Decomposition Tree Extension for Qlik Sense.
2. Open Qlik Management Console (QMC): https://<QPS server name>/qmc
3. Select Extensions on the QMC start page or from the Start drop-down menu.
4. Click Import in the action bar.
5. In the dialog, select the downloaded archive. Leave the password area blank.
6. Click Open in the file explorer window.
7. Click Import.

Qlik Sense Cloud

To install Decomposition Tree Extension in Qlik Sense Cloud, do the following:

1. Download Decomposition Tree for Qlik Sense Cloud.
2. Extract the archive.
3. Access the Management Console:
   • add /console to your tenant address: https://<your tenant address>/console
   • or use the navigation link Administration under the user profile in the hub
4. Go to the Extensions page and click Add.
5. In the dialog, select the archive with the extension in the bundle – for example, anychart-4x-decomposition-tree.zip.
6. Click Add.
7. Repeat the steps above to add other extensions.
8. In the Management Console, go to the Content Security Policy section and click Add.
9. In the dialog, give the Content Security Policy a name – for example, AnyChart.
10. Type the address of the origin server: qlik.anychart.com
11. Select the following directives:
    • connect-src
    • font-src
    • img-src
    • script-src
    • style-src
12. Click Add.

Overview

The decomposition tree allows you to view data across multiple dimensions. It automatically aggregates data and allows you to drill down into your dimensions in any order. This tool is valuable for ad hoc exploration and for conducting root cause analysis.

Read Quick Start and Dimensions and Measures to learn how to add a Decomposition Tree and what dimensions and measures to use.

The available settings include: colors, color by expression, color by measure, level settings etc.

Demos

To help you better understand what a decomposition tree is and how to use it, we prepared several great demos, which you can check out in Decomposition Qlik Demo Apps section. There is a general Decomposition Tree in Qlik Sense Features demo app, IMDB Top 1000 Slice and Dice analysis app, Tech layoffs app, and others.

Quick Start

This quick tutorial explains how to create a basic Decomposition Tree.

You can also check out a short video tutorial: How to work with a Decompositon Tree in Qlik Sense.

First of all, add an empty chart to your sheet:

1. Go to Custom objects > AnyChart in the assets panel.
2. Drag an empty Decomposition Tree chart to the sheet.

Then add dimensions you wish to analyze:

1. Go to Data > Dimensions in the properties panel.
2. Click Add dimension and select a dimension.

Repeat this step as many times as you need:

Finally, add a measure to be analyzed:

1. Go to Data > Measures in the properties panel.
2. Click Add measure and select a measure.

Please note that you can also create dimensions and measures from fields or add them by clicking on the buttons on the empty chart.

Dimensions and Measures

Dimensions

To add a dimension, do the following:

1. Go to Data > Dimensions in the properties panel.
2. Click Add dimension and select a dimension.

The Decomposition Tree requires only one dimension. However, it makes more sense when multiple dimensions are added.

This order of dimensions will only affect the representation of dimensions in the breadcrumbs dropdown and drill-down navigation drop-down.

If you need to hide null values, uncheck the Include null values box in the settings of each dimension.

Measures

To add a measure, do the following:

1. Go to Data > Measures in the properties panel.
2. Click Add measure and select a measure.

At least one measure should be provided to the decomposition tree.

Alternative Measures

You can provide alternative measures to the decomposition tree and switch between them on the fly while using the chart.

To add an alternative measure, do the following:

1. Go to Data > Measures in the properties panel.
2. Click Add alternative and select a measure.

When alternative measures are provided the dropdown control appears on the root element and you can click it to switch between alternative measures.

Colors

Positive values cover the whole bars of the respective elements in the decomposition tree (Note the scaling mode). But when there is at least one negative value on a level, the element bar gets split into two equal parts: negatives grow to the left, and positives grow to the right. To make the reading of the data even easier, the parts are colored differently.

The colors of bars can be modified in the extension's Appearance > Colors sections.

Single Color

If you want to set the static color of positive bars and negative bars:

Go to Appearance > Colors > Bar Color section, choose "Custom" option and select "Single Color" from "Color by" dropdown and choose solid colors for Positive and Negative bars.

Color by Measure

If you want to color bars according to measure value:

Go to Appearance > Colors > Bar Color section, choose "Custom" option and select "Color by measure" from "Color by" dropdown.

Color by Expression

If you want to color bars according to any kind of custom conditions:

Go to Appearance > Colors > Bar Color section, choose "Custom" option and select "Color by expression" from "Color by" dropdown.

Connectors

Connector is a line that runs from one level to another, this line can be in "Active" and "Inactive" state. To change the coloring of the connectors:

Go to Appearance > Colors > Connector Color section, choose "Custom" option and select colors for "Active" and "Inactive" states.

Bar Scale

The length of the value bars can be calculated in three ways:

• Relative to the maximum value per level to compare values within each level - which is a default value;
• Relative to the parent value to compare contributions to the parent;
• Relative to the root element to compare contributions to the total.

To change the behavior: go to Appearance > Presentation > Scale bar to in the properties panel and choose the desired option from the dropdown.

Header

You can tune the appearance of the Decomposition Tree header, or breadcrumbs, disable it, change background and other colors, fonts styles, and icons.

If you wish to disable header: go to Appearance > Header settings in the properties panel and uncheck the Display header slider.

If you wish to change the colors, fonts, icons: go to Appearance > Header settings in the properties panel, switch the appropriate slider from Auto to Custom, and provide proper values in the settings that appear.

Levels

You can choose the way the elements of the tree are displayed in your dashboard depending on the space available and the nature of the values in the dimensions.

Width

If you wish to change the width of the levels go to Appearance > Presentation > Level size in the properties panel and choose one three options from the dropdown box:

• Compact
• Normal (default)
• Wide

Paging

You can limit the number of elements displayed on each level. The elements that are not displayed are still there and can be accessed by paging up or down with the help of arrow controls. Hitting the triple dots reveals the hidden elements.

To enable paging, go to Appearance > Presentation > Limit items per column in the properties panel and check the checkbox. This setting ensures that only screen-fitting elements appear, concealing others. Use the "Min items per column" slider to set the minimum number of elements displayed on each level.

Drill Down Mode

By default decomposition tree allows the end user to choose any dimension to drill into and change the order on the fly, that is what we call "Flex dimensions". You can make the order of drilldown static if you wish to, thus limiting the way how analysis may go.

To disable Flex mode go to Appearance > Presentation > Use flex dimension in the properties panel and uncheck the checkbox.

Interactivity

By default, the following interactivity features are available: selections, snapshots, and tooltips.

To disable or enable these features, go to Interactivity in the properties panel and switch the following sliders:

• Selections
• Snapshots
• Tooltips

UI Sorting

UI Sorting allows users to sort elements of a tree according to the measure in a runtime. UI sorting is available via context menu that appears when you hover the header and hit the accordion icon.

By default, UI Sorting is disabled.

To enable UI Sorting, go to Interactivity in the properties panel and switch the following slider:

• UI Sorting

Calculation Conditions

Decomposition Tree supports calculation conditions: you can set a condition that needs to be fulfilled (true) for the object to be displayed. If the condition is not fulfilled, a custom message is displayed.

A calculation condition is useful when a number of elements in the tree very big and makes the visualization slow to respond. A calculation condition can then help so that for example an object does not show until the user has filtered the data to a more manageable level by applying selections.

To add a condition, do the following:

1. Go to Add-ons > Data handling in the properties panel.
2. Enter an expression in the Calculation condition input box.
3. Enter a string value or a string expression in the Displayed message input box.