Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make my chart bar turn yellow when GP% less then 15% ?

Hi All
May i know how to make my chart display as below :-
1. if GP > 30% Dark Green
1. if GP > 15% <30%  Light Green
1. if GP < 15% light Yello
Now all bar are black
Paul
1 Solution

Accepted Solutions
paulyeo11
Master
Master
Author

Hi Sir

Very smart why. Thank it work.now.

Paul

View solution in original post

3 Replies
paulyeo11
Master
Master
Author

Hi All

My QV Doc

mvanlutterveld
Partner - Creator II
Partner - Creator II

Hi Paul,

I changed the name of your GP% expression to: GP%. In the Background Color attribute of the Sales expression I entered the following nested if:

If(GP% > 0.3,rgb(0,128,0)

  ,If(GP% < 0.15, RGB(255,255,98), RGB(0,255,0))

  )

This resulted in the following:

Capture.PNG

Is this what you're looking for?

Cheers,

Michiel

paulyeo11
Master
Master
Author

Hi Sir

Very smart why. Thank it work.now.

Paul