Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gfisch13
Creator II
Creator II

Color a single bar

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))

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Your expression should work.

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

Can you share the sample?

Capture.JPG

View solution in original post

3 Replies
settu_periasamy
Master III
Master III

Your expression should work.

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

Can you share the sample?

Capture.JPG

gfisch13
Creator II
Creator II
Author

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?

settu_periasamy
Master III
Master III

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.