QlikView – Color Blend by Dimension Value


Sometimes you wanna define a “color schema” by the values of a dimension. The easiest way is to generate a mapping table where each dimensionvalue gets an color assigned.


First load the color table as CSV from here and save them into the same folder where you wanna create and run the QlikView Worksheet:


If you wanna update the colors “online” just replace the first load with:
After this we create a bar chart with the YourFieldname as Dimension and 1 as Formula:

Screenshot 2015-04-02 12.55.30

To color it as we wanted to, we will edit the background formula for the formula as here:

Screenshot 2015-04-02 14.26.18Which leads us to the following result:

Screenshot 2015-04-02 14.27.15