Qlik Sense Extension 2 Dimensional Heatmap

---

Caution:

This Qlik Sense extension is discontinued since it became part of the Qlik Visualization bundle in version November 2018 SR2. A couple of feature were removed though...

You can find a supported version with more features, which can be customized also, at TIQ Solutions.

---

This extension shows a matrix of colored tiles by two dimensions. The 1st dimension is used for the rows (variable, scrollbar if exceeds container element), 2nd dimension is used for the columns and should have a fixed maximum fitting to the container.

For best adoption use a numerical dimension for the 2nd dimension (columns) with a very short label like week (label: 01..53)

Based on: d3 day/hour heatmap for Qlik Sense Source : http://branch.qlik.com/projects/showthread.php?348-d3-day-hour-heatmap-for-Qlik-Sense

GitHub : https://github.com/borodri/Sense_d3calendarheatmap

Author : https://github.com/borodri

The extension and example app was created during the Qonnections 2015 Hackathon (Team Sixth Sense: Torben Seebach, Matthieu Burel, Ralf Becher)

After that I've added a bit more responsiveness for the grid layout, labels, font sizes and enable scrolling.

You can make a selection by one dimension by clicking on a dimension label (row or column) or a selection by two dimensions by clicking on a tile.

Also, you can use a lasso to make a two-dimensional selection:

Additional Properties:

1. Color Schema: color schema for measure visualization on tiles
2. Use Mean in Scale: calculate mean of data set and use it as middle value in color scale
3. Fixed Scale: use min/max/mean expressions to define a fixed color scale independent from data set, esp. independet from selections, means selected tiles will have consistent color
4. min. Scale Value: expression for minimal value to define start of color scale
5. max. Scale Value: expression for maximal value to define end of color scale
6. mean Scale Value: expression for mean value to define middle of color scale, set to 0 when no mean should be used
7. Show Legend: show/hide legend
8. Dim1 Label Size (left): max. amount characters shown of 1st dimension label (from left)
9. Dim2 Label Size (right/rotate left): max. amount characters shown of 2nd dimension label (from right, or from left if rotated)
10. Rotate Dim2 Labels by -90°: rotate labels counterclockwise, better for more readable labels above small tiles
11. Max. Columns for Grid: expression to get max. amount of values of 2nd dimension to have a more stable grid layout
12. Height Factor: a multiplier to change rectangular high of tile (default=1, 100% - same size as width)
13. Least Tiles in Row: filter rows (1st dimension) with less than minimum amount of tiles (default=1; no filtering)
14. Localized Number Format: use a localized number format for decimal and thousands separator
15. Show Numbers in Tiles: shows the measure number in each tile (only useful for small numbers, depending on tile sizes)
16. Render Tiles w/ Border: switch tile border on/off (default=on)
17. Tile Opacity: set opacity to tile color (default=1, no opacity)
18. Lasso Selection: activate lasso selection (default=on)
19. Show condition: QlikView-like show condition; useful if you have a measure or selection which doesn't gives you values. If condition <> 1 at least the labels of 1st and 2nd dimension are shown but no tiles.

Sample Application:

Qlik Hackathon 2015 Start.qvf - Uses data from Medair to analyse Ebola Outbreak in Sierra Leone.

This app uses also Qlik Sense Extension VariableButton: https://github.com/asierfer/QlikSense-Ext-VariableButton

With class() function as measure dimension you can have a awesome fast backend calculated binning!

Rotation of Dim2 Labels and proper measure formattings:

Author

Ralf Becher

• irregular.bi

• twitter/irregularbi
• github.com/ralfbecher

License

Copyright © 2015 Ralf Becher

Released under the MIT license.

---