topic Re: Color a single bar in QlikView

Color a single bar

gfisch13 — Wed, 25 Nov 2020 16:16:04 GMT

Hi - I have a bar chart that is showing the aging of cases,

I want to change the color of the 120+ bar to red. I've tried a conditional statement in the Background Color section of the expression, and have also tried the same conditional on the colors tab. My expression is below and the chart is attached.

Not sure what I'm doing wrong. Thank you!

I've tried both of these:

=If(Buckets = '120+')

=If(Buckets = '120+', RGB(255,0,0))

Re: Color a single bar

settu_periasamy — Thu, 22 Feb 2018 20:25:28 GMT

Your expression should work.

Can you remove the 'expression' in the Colors tab and try?

Can you share the sample?

Re: Color a single bar

gfisch13 — Mon, 26 Feb 2018 15:04:41 GMT

Thanks for the response - what I've come to find out is that the formula is in fact working, but not on my machine. If I pass the QVW file to a coworker it works, why would that be?

If I wanted to color other bars in my chart, what would be the easiest way to nest those functions?

Re: Color a single bar

settu_periasamy — Tue, 27 Feb 2018 06:16:07 GMT

George Fischetti wrote:

Thanks for the response - what I've come to find out is that the formula is in fact working, but not on my machine. If I pass the QVW file to a coworker it works, why would that be?

Try to recreate the chart.

If I wanted to color other bars in my chart, what would be the easiest way to nest those functions?

Did you try the Multicolored option? If you want the specific colors in a bar, you can try with Pick(Match(..)..) instead of nested if.