Overview

The colormix in Qlikview is a function that allows for different colors to be used in lieu of the default color scheme. As it states, it mixes colors depending on the minimum limit and maximum limit of an expression. There are several ways to create heat maps, but this should help with creating simplified heat map

In this tutorial, we will be demonstrating the usefulness of the colormix wizard and how it can be used effectively for a simple dataset.

 

Method

Using the colormix wizard in Qlikview is relatively easy and comes in handy. It can be used for heat mapping or just to bring attention to the highest value or lowest value. In this example, we will be using some Major League Baseball team win data.

  • Open up Qlikview.
  • Right Click > New Sheet Object > Chart

  • Add “Team” as the dimension.

  • Go to expression tab. Create the expression Sum(Wins).
  • On the expression you want to use the heat map on, expand the expression to show the Background Color.
  • In the space for the definition, expand that by clicking on the “” button. (Please see below image)

  • Click File > Colormix Wizard

  • Once you have clicked on the Colormix Wizard, you should see a dialog that allows you to put in the expression that you want to use. This could be any expression you want, this depends on your requirements and what you want to display. For our purposes, we will use the expression sum(Wins)

  • After clicking next, you should see the below dialog. As the below image shows, this is where you stipulate the limits. In my example, I used the auto normalized check box and changed the lower limit to white instead of red.

  • Click Finish
  • The wizard will then generate an expression, in the edit expression pane. Here, you can change the expression that was generated by the wizard to whatever you like. This is in case you made a mistake, you can make changes to the expression. It is also useful if you want to re-use the same expression but just want to make a few adjustments.

  • As can be seen, the biggest contingent is the greenest block and the smallest is white. This can also be reversed in the colormix wizard if you want it the other way around.

 

 

  • If you are wanting to use a block chart, you are most likely going to want to use colormix to change the default color gradient. As you can see below, the default color patter for the same report is pretty ugly.

This should help get you started with using the colormix functionality in Qlikview. If you have any questions or comments about the blog post or with Qlikview in general, please contact me at the following:

Kiel Briggs

kbriggs@ecapitaladvisors.com