Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
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

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

your solution is brilliant !

Thanks for your help.

View solution in original post

2 Replies
Highlighted
Partner
Partner

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

your solution is brilliant !

Thanks for your help.

View solution in original post