topic Re: Color change based on Numberical Value range in QlikView

Color change based on Numberical Value range

nramirez — Mon, 12 May 2014 23:56:24 GMT

I have a Gauge and would like to make my Colors on my bar chart match the ones from my Gauge.

I don't know what would be the best method to use or how my code should look like. I was thinking about a nested If Statement, but don't know how I would write it.

What I'm trying to do is to set my colors the following way.

23.5 > Green

18.1 > Yellow

0 > Red

Thanks in Advance

Re: Color change based on Numberical Value range

Tue, 13 May 2014 00:02:01 GMT

You can go the expression of the bar chart and change the background color as desired with the if condition.

if ( <expr> <= 25, green(), if <expr> > 25 and <expr> <50, blue()................................

Re: Color change based on Numberical Value range

nramirez — Wed, 14 May 2014 23:19:12 GMT

Thank You.. Worked Perfectly.