Discussion Board for collaboration related to Creating Analytics for QlikView.
I am trying to create an expression for colours which I am able to do for two colours but I need 3 colour change.
I need the colour to be green when my QS is >= 90RGB(0,128,0)
and red when it is below 90 RGB(255,0,0)
and white when it is below 85 RGB(255,255,255).
I am using the if statement for like
However, I cannot find a way to integrate the third condition and the third colour in my expression.
Go to Solution.
add another if
if(QS >= 0.9, RGB(0,128,0), // >= 90 green
if(QS < 0.85, RGB(255,255,255), // < 85 white
RGB(255,0,0) // >= 85 <90 red