Using ColorMix In Qlikview

    Introduction

     

    The colormix function in Qlikview is a function that allows for different colours to be used. As it states, it mixes colours depending on the minimum limit and maximum limit of an expression. It is with this function that simplified heatmaps can be created in Qlikview. There are however, other ways to create heatmaps.

     

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

     

    Method

    Using the colormix function in Qlikview is relatively easy and comes in handy. It can be used for heatmaping or just to bring attention to the highest value or lowest value. In this example, we will be using the MySQL localhost sample data. Have your data ready, as well as the expression you would like to use. It would help if you had a chart already created to test the function on. The following are steps to follow to use the function:

    • Open up Qlikview.
    • Go to the chart you want to test the function on.
    • Right click on the chart and choose properties.
    • Go to expression tab. On the expression you want to use the heatmap 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)

    2016-04-15_09-00-54.png

    • After clicking on the "..." button, you should see an empty Edit Expression dialog. Go to file and then select Colormix Wizard. (See below)

    2016-04-15_09-03-32.png

     

    • 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(countrySurfaceArea).

     

    2016-04-15_09-04-14.png

    • After clicking next, you should see the below dialog. As the below image shows, this is where you stipulate the limits. In our example, the upper limit was 32 000 000 and the lower limit was 1000. Click Next after the stipulations.

     

    2016-04-15_09-04-52.png

    • We will then see the below. This is in the edit expression. Here, you can change the expression that was generated by the wizard to however you want. 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 tweek a few other things.

     

    2016-04-15_09-09-59.png

    Conclusion

    At the end of this tutorial, you should have the following:

     

    2016-04-14_10-17-22.png

    As can be seen, the biggest continet is the reddest block and the smallest is green. This can also be reversed in the colormix wizard if you want it the other way around. More examples, if you change the chart type, are:

     

    2016-04-14_10-16-43.png2016-04-14_10-16-19.png

     

    Reference

     

    1. Qlikview ColorMix Wizard by RFB 169 - YouTube. 2016. Qlikview ColorMix Wizard by RFB 169 - YouTube. [ONLINE] Available at: https://www.youtube.com/watch?v=YasIe3VUJrg. [Accessed 07 July 2016].
    2. Qlikview Heatmaps | Qlik Community. 2016. Qlikview Heatmaps | Qlik Community. [ONLINE] Available at: https://community.qlik.com/thread/79307. [Accessed 07 July 2016].
    3. Thabang Petje. 2016. Thabang Petje. [ONLINE] Available at: http://source.entelect.co.za/thabang-petje. [Accessed 07 July 2016].