Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: target color not showing correct in bar chart

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

Highlighted
Creator III
Creator III

Re: target color not showing correct in bar chart

your solution is brilliant !

Thanks for your help.

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: target color not showing correct in bar chart

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

Highlighted
Creator III
Creator III

Re: target color not showing correct in bar chart

your solution is brilliant !

Thanks for your help.

View solution in original post