Qlik Sense Visualization Extension with a diverging color scale. The values are displayed as colored cells per day. Days are arranged into columns by week, then grouped by month and years.
- Download the latest version
- Qlik Sense Desktop
- To install, copy all files in the .zip file to folder "C:\Users%USERNAME%\Documents\Qlik\Sense\Extensions\swr-CalendarHeatmap"
- Qlik Sense Server
- See instructions how to import an extension on Qlik Sense Server
There is also a demo available, if you want to see a working example.
After installing the extension the following properties can be set:
| Property | Description | Values |
|---|---|---|
| Unique day | Field containing the unique day. Note that you just have to type in the field name without equal sign (=). |
Example:Dim1 or [Dimension with Space] |
| Value | Expression which needs to result in a valid numeric number (positive or negative). Note: Define the expression without a leading equal sign ( =). |
Example:[round(Sum([TableX.FieldWhatever]),0.001) |
| Tooltip: | You can (optionally) define the tool tip display when hovering a day. |
If you want to see which data are passed to the Calendar Heatmap visualization, you can temporarily enable the Debug Mode. By doing so only the data returned from the QIX engine will be displayed in a table.
The Debug Mode can only be activated and you'll only see the resulting table in Edit Mode of Qlik Sense.
- For performance reasons only 1500 rows will be returned (so 1500 days).
I'd like to look into the following areas to improve this Visualization Extension for Qlik Sense:
- Skip rendering of years not included in the data
- Performance improvements
- Better, configurable label
- Offer also a week view and maybe other views
- Support selections (both single days, weeks and years)
Contributing to this project is welcome. The process to do so is outlined below:
- Create a fork of the project
- Work on whatever bug or feature you wish
- Create a pull request (PR)
I cannot guarantee that I will merge all PRs but I will evaluate them all.
Stefan Walther
See CHANGELOG.md
The software is made available "AS IS" without any warranty of any kind under the MIT License (MIT).