topic Re: Barchart Colors based on Values in QlikView

Barchart Colors based on Values

Mon, 24 Nov 2014 18:52:43 GMT

Hello Experts,

I have the following scenario, I am showing all students marks in bar chart, I would like to display Highest score in Green color, lowest score in Red color, rest all in regular gay color. how to give the color code?

I have used Rank function, but with this I can show only either Highest or Lowest color change not both at once. please help me.

Thanks

San

Re: Barchart Colors based on Values

jpapador — Mon, 24 Nov 2014 19:07:18 GMT

On the expression tab hit the "+" next to the expression and you will see and option called background color. Enter your expression there.

If(Score = Max(Score), Green(), If(Score = Min(Score), Red(), RGB(125,125,125)))

You could also use rank in place of min and max

Re: Barchart Colors based on Values

Anonymous — Mon, 24 Nov 2014 19:25:04 GMT

Hi,

In Background color of the dimension/expression please give below syntax:

= If(Grade= 'Highest', RGB(168, 189, 11),

If(Grade= 'Lowest', RGB(228, 31, 31),RGB(125,125,125)))

Hope it helps

Cheers

Neetha

Re: Barchart Colors based on Values

MarcoWedel — Mon, 24 Nov 2014 23:12:15 GMT

Hi,

one solution could be:

When using the Min/Max approach, you have to compare against the TOTAL min or max.

hope this helps

regards

Marco

Re: Barchart Colors based on Values

Tue, 25 Nov 2014 14:47:18 GMT

Awesome , Thank you Marco.. 🙂

Also, Thank you All 🙂

Re: Barchart Colors based on Values

MarcoWedel — Tue, 25 Nov 2014 15:07:18 GMT

You're welcome

Regards

Marco