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: 
0li5a3a
Creator III
Creator III

target color not showing correct in bar chart

Hi All,

I have a challenge to display the right colours in a bar chart when I have MSL = 85% and TSL 90%.

I have used this   calculation in my expression's background color :

if([PM Value] > '85%' and [PM Value]<'90%',RGB(255,215,0),
if( [PM Value]<='85%', rgb(255, 0, 0),RGB(0,255,0)))

The color didn't turned in Red if is <=85% and also  is not Orange when is < 90.

I supposed to display red if is less or equal with 85%,  Orange  if is over 85% but less than 90%, and Green all above 90%.

 

Please find the app attached.

Capture.PNG

2 Solutions

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

See attached.

changed the color expression to

if(num#([PM Value]) > .85 and num#([PM Value])<.9,RGB(255,215,0),
if( num#([PM Value])<=.85, rgb(255, 0, 0),RGB(0,255,0)))

View solution in original post

0li5a3a
Creator III
Creator III
Author

your solution is brilliant !

Thanks for your help.

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

See attached.

changed the color expression to

if(num#([PM Value]) > .85 and num#([PM Value])<.9,RGB(255,215,0),
if( num#([PM Value])<=.85, rgb(255, 0, 0),RGB(0,255,0)))

0li5a3a
Creator III
Creator III
Author

your solution is brilliant !

Thanks for your help.