QlikView – Color Blend by Dimension Value

Overview 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. Downloads 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:  http://www.beeye.org/wp-content/plugins/download-monitor/download.php?id=3  Sample

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: To color it as we wanted to, we will edit the background formula for the formula as here: Which leads us… Read More

Continue Reading