How to create heatmap in QlikView
A Heatmap chart displays comparative data where the values, represented as color patterns, convey information in a faster way
Example of a heatmap
Step 1:
Create a new chart on your dashboard, by right clicking on the sheet and adding a new chart.
Select the dimensions and expressions.
You can choose to group your data by one or more dimensions.
You should see a table similar to the figure below
Step 2:
In the chart property, select the background color of your measure expression then its definition property.
As seen on the figure below
Step 3:
Select the ColorMix wizard which can be found from the File Tab > Colormix Wizard.
Step 4:
The ColorMix Wizard description shows the wizard helps to create a function that generate dynamic colors based on your measure. Click on ‘Next’ to continue, as seen below:
Step 5:
Add (copy/paste) the Expression used on the chart then proceed to the next step. In this example, the expression is a Sum formula, as seen below:
Step 6:
Define the range and color, in this instance using Auto Normalize will automatically look for the high and low value compared to specifying the limit (upper/lower limit) when unselecting Auto Normalize.
Step 7:
Define the range and color, in this instance using Auto Normalize will automatically look for the high and low value compared to specifying the limit (upper/lower limit) when unselecting Auto Normalize.
Step 8:
An expression is automatically generated to represent the conditions that have been specified in the wizard, as seen below.
On clicking on ‘OK’, the generated ColorMix expression is inserted to the definition of the background color.
Step 9:
The figure below shows the updated expression’s background color definition. Click on ‘OK’ to complete the process.
Step 10:
This generates a color pattern represented by darker color for the higher values to lighter color for the smaller values, as seen below. You can modify the colors / saturation in the Step 6 of this guide. Choosing colors by upper/ intermediate and lower values instead of ‘Auto Normalize’.
Note:
You can modify the colors / saturation in the Step 6 of this guide. Choosing to set colors by upper/ intermediate and lower values instead of ‘Auto Normalize’.
Do you need temporary assistance on Qlikview?
We offer direct assistance and training through Teams/ Zoom/ Webex. Our Bi consultants have followed official Qlik courses and have been certified in order to bring you the best possible quality. Our trainers have over 3 years of extensive Qlikview, Qliksense and Nprinting development experience and are very active in terms of delivery and keeping up with Qliktech’s latest advancements.
Join our dozens of Qlik customers and let us help you build your valuable reports.
