Discussion Board for collaboration related to QlikView App Development.
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.
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
your solution is brilliant !
Thanks for your help.