You can choose between the following media for Traffic Light Extension for QlikSense:

Flip Book

Subscribe here to receive exclusive updates and releases: Subscription


Introduction Traffic Light Extension for QlikSense

Keep track of your project status and any kind of threshold with this visual traffic light solution! This is the major objective of this traffic light extension. “Traffic Light” is a highly customizable Qlik Sense Extension for monitoring your KPIs. Multiple settings like horizontal and vertical alignment or a two/three light system adapts this extension to your reporting needs.

Traffic Light Extension for QlikSense

Traffic Light Extension for QlikSense 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: Show Project Status in a Project Management Dashboard

IT: Indicate exceeding of system performance threshold in an IT-Performance-Monitoring Tool

Infrastructure: Show buildings, where a threshold for incidents and repairs is exceeded, which leads to a general evaluation of heavy maintenance

Traffic Light Extension for QlikSense
Example Dashboard

Getting Started

Open Qlik Sense and the relevant app, where you want to use the “Traffic Light” extension. Open your worksheet in edit mode and you will find the “Taffic Light” extension as well as all your other purchased LeapLytics extensions under “LeapLytics Bundle” 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
  • Ranges
  • Appearance
  • Navigation & Action
  • About

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


Measures

The measure defines the value, that is processed together with the ranges to create the colors of the traffic light. The measure can have all possible QlikSense-Formats. 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.)

These expressions also need to be considered when defining the ranges. Please select the format of the measure accordingly.

Traffic Light Extension for QlikSense
Example Intervall
Traffic Light Extension for QlikSense
Example Date

Ranges

Traffic Light Extension for QlikSense

When “Ranges” is clicked, you can select between “Three Lights” or “Two Lights” in order to adjust the look of your traffic light (Keep in mind, that the yellow interval is not applied, if ou select „Two Lights“ in the “Light System” properties – all described use cases can be applied). 

Afterwards, define the individual ranges with “Min” and “Max” values in order to set the intervals of each colour. Please use the format-formulars according to the measure-formular. 

The basic logic for all user cases is: From small values (red) to high values (green). For detailed use cases, see the table below. 


Advanced Settings

Alignment / Size: You can use the alignment switcher to bring your traffic light in a vertical or horizontal position.

Borders: With the border setting, you can adjust the appearance of the traffic light to your needs. “Traffic Light Border” enables or disables the outer borders of your system. “Traffic Light Shades” enables or disables the inner borders of the lights. 

Text: You can apply changes to your text within the “Text Settings” properties. Show or hide text with the “Text Visible” switch. Change the size of the text with the “Font Size” slider. You can change between bold text and normal text with the “Font Style” switcher. 

Navigation & Actions: 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


Compability

This extension has been tested with:

Qlik Sense 2020/09

Qlik Sense 2019/09


Version History

Version Date Content
1.0 24.11.2020 Initial Version
1.1 09.12.2020 – Subscription
functionality for
release upgrades 
– Optimized space
within horizontal
alignment 
1.2 22.04.2021 Navigation & Actions added,
improved properties panel