Using the colormix1 function

Heat maps are a common requirement in most of the BI implementations. A colormix1 function helps to create a gradient between two colors. Look at the following recipe to understand the use of this function.

Getting ready

We will make use of a simple inline load for this recipe. Perform the following steps to get started:

1. Create a new Qlik Sense application. Name it HeatMaps_Colormix1.
2. Open the Data load editor.
3. Load the following script that gives you information about actuals and budget for products:

Products:
LOAD * INLINE [
Product, Actuals, Budget
Footwear, 100000, 120000
Tyres, 180000, 150000
Mountain Bikes, 250000, 195000
Road Bikes, 200000, 225000
Chains, 80000, 90000
Helmets, 240000,160001
Gloves, 56000,125000
Pedals, 45000,100000
Rucksacks, 300000,450000
];

How to do it…

1. Open the App overview and create a new sheet.
2. Create a Bar chart on the sheet
3. Use Product as the dimension.
4. Use Sum (Actuals) as the measure and label it as Actuals.
5. Switch off Auto colors to activate...