topic Re: Scaled Conditional Coloring in QlikView

Scaled Conditional Coloring

ysiroong — Thu, 11 Aug 2016 15:13:49 GMT

Is it possible to add conditional coloring to a column that's not based on set values?

Instead of setting the background color to green when value is greater than x, I want to have a range of colors that will scale with the data set.

So let's say I have a table with 3 rows and 1 revenue column. I want to color the max revenue column green, the mid revenue yellow, and the least revenue red, regardless of what the amount is.

Is this possible?

Re: Scaled Conditional Coloring

Gysbert_Wassenaar — Thu, 11 Aug 2016 15:33:14 GMT

Yes, that's possible. Click on the + in front of the expression on the Expressions tab. Select Background Color and enter an expression that calculates the color in the Definition input field. You can add all your conditions and the matching colors in that expression.

Re: Scaled Conditional Coloring

jpenuliar — Thu, 11 Aug 2016 15:34:42 GMT

Hi Robert,

Assuming you already are familiar with the functions Min.Median & Max in qlikview,

You can use them in Expression Background Color property to apply colors.

Re: Scaled Conditional Coloring

effinty2112 — Thu, 11 Aug 2016 15:37:18 GMT

Hi Robert,

We have a lot of flexibility in how we can colour cells by setting the background colour using a formula.

For your example I would try something like

Pick(Rank(sum(Revenue)),Green(),Yellow(),Red())

Kind regards

Andrew

Re: Scaled Conditional Coloring

ysiroong — Thu, 11 Aug 2016 15:50:39 GMT

Thanks! This looks like it would be closest to what I'm looking for. Is it possible to generate the color ranges dynamically? The data set I'm working with isn't just confined to 3 records. The table I'm working on is 5 regions and each region has a different number of areas. So one region may need 10 different color ranges while another might need 15.

Re: Scaled Conditional Coloring

effinty2112 — Thu, 11 Aug 2016 16:53:27 GMT

Hi Robert,

You can write a Pick expression with 15 or more choices of colour and you can use it any of your charts. Such an expression would work equally well if you have three dimensional values or fifteen.

You could experiment with the ColorMix wizard too.

Kind regards

Andrew

Re: Scaled Conditional Coloring

ysiroong — Thu, 11 Aug 2016 16:54:56 GMT

I think the ColorMix Wizard is exactly what I'm looking for.

Thanks Andrew!