You can choose between the following media for Risk Heatmap Extension for QlikSense:

Flip Book

Subscribe here to receive exclusive updates and releases: Subscription


Introduction Risk Heatmap Extension for QlikSense

Get a sharp visual view on your risk profiles with the Risk Heatmap for QilkSense! This extension is built to visualize profiles, that are measured in a matrix of two KPIs and different categories. It is able to visualize multiple indicators (up to 4 in free version) per field. Various settings like an easy switch between a 3×3- and 5×5-field-matrix, border and text settings adapts this extension to your reporting needs.

Risk Heatmap Extension for QlikSense

This extension can also be used for monitoring and indicating thresholds for all types of physical measures, quality indicators and divergences in general. With this, it can be applied to a broad number of uses cases, that occur different businesses. The following listing shows a selection of possible uses cases, that had been already implemented:

Project Management: Visualize risk and opportunity profiles for a project, program or portfolio

IT: Indicate applications, that are in green, yellow or red area of status (performance, health)


Getting Started

Open Qlik Sense and the relevant app, where you want to use the “Risk Heatmap” extension. Open your worksheet in edit mode and you will find the extension within the “Custom Objects” section. Drag and Drop the extension to any area on your dashboard (You can change the appearance of the extension later in the advanced settings).

After you have placed an instance of the extension to your dashboard, the following properties panel will appear on the right side. The properties panel is separated into the following sections:                                                                                              

  • Measures
  • Dimensions
  • Ranges (general matrix layout)
  • Grid Settings (everything inside the matrix)
  • Axis Settings (everything around the matrix)
  • Indicator Settings (everything regarding matrix-content)
  • About                                             

In the following , you will learn how to use LeapLytics “Risk Heatmap” extension and how to customize it to your needs by using the properties correctly.   


Measures

The measure defines the value for the relevant two KPIs of the matrix. The first KPI defines the X-Axis-KPIs and the second KPI defines the Y-Axis-KPI. They can be switched individually. The matrix is expecting values in the range between 1 and 5 (5-field-matrix) or 1 and 3 (3-field-matrix). Also decimals are possible, if useful. The values can be taken from the data model directly, if a pre-system is already capturing and calculating the range. If the data model includes any kind of units, the categories can be created within the formular individually.

You can add a measure like this:

  • Click the “Add measure” button in the properties panel under the section “Measure” or by clicking the “Add measure” button inside the extension window on your dashboard
  • Choose a measure from the dropdown list and click on it
  • (Optional): Choose the right aggregation for your needs (Sum, Avg, Min, Max, etc.) or define an individual formula.

When using individual formulas, the following examples can be taken as a guidance:


Dimensions

Use the dimension in order to give the indicators a striking name. This can be e.g. an ID or short-name (1-2 words). Longer names or descriptions are not recommended, as the space of the matrix itself is limited.


Ranges

The ranges section lets you switch between a 3×3 or 5×5-field matrix.

Depending on the matrix ranges, the categories coming from the data have to be adjusted accordingly.  If the data model includes values, that does not fit into the matrix-system, an indication will show the user, that values are out of range.


Advanced Settings

Grid Settings: Use the Grid Settings to configure the matrix itself, e.g. size or configuration of the borders. You can also invert the colour-coding, that a higher category has the colour “green” and a lower category is turning into red. It is also possible to switch off the table with detailed values.

Axis Settings: The Axis settings let you configure the frame to your needs. You can decide to switch off texts, axis or high/low-indication.

Indicator Settings: Use the indicator settings in order to change the size and appearance of the indicators in the Grid.

Risk Heatmap Extension for QlikSense

Navigation & Action

You can apply Navigation & Actions to your extension to navigate to QlikSense Sheets, websites, etc. Actions need to be activated with the corresponding button. “Milestone View” supports two different navigation types:

  • Button: Choose “Button” to add a button underneath your traffic light icon. You can rename the button by using the “Button Text” field. Enter a URL for a website or QlikSense Sheet you want to navigate to*. You can open the URL in the same window or in a separate tab by using the “Open in same window” checkbox.
  • Object: Choose “Object” to make the entire object clickable (“Button Text” field will be hidden). Enter a URL for a website or QlikSense Sheet you want to navigate to*. You can open the URL in the same window or in a separate tab by using the “Open in same window” checkbox.

*URLs always have to start with “http://www.” or “https://www.”


About

This Qlik Sense extension is developed by LeapLytics. The About-Section show information regarding this extension.

Version: Shows the installed version of this extension

License valid until: Shows the license expiring date

License valid on server: Shows on which server ID this extension can be used


Version History

VersionDateContent
1.013.11.2020Initial Version
1.128.01.2021Subscription
functionality for
release upgrades &
improved properties panel
1.226.04.2021Navigation & Actions added,
More than 9 risks support
scrollable indicator table