Discussion board where members can get started with QlikView.
I have this column called cost and I have to set rgb based on the below criteria.
If cost > 0 then Green
if Cost = 0 to -5 then Yellow and if Cost < - 5 then Green.
How can I write this in calculated condition in color ?
Try below expression,
If(cost >0 or cost <-5 , LightGreen(), Yellow())
My bad...below is what I want.
If cost > 0 then Red
I guessed it.
If(cost>0, Red(), If(cost <= 0 and cost >=-5, Yellow(), If(cost <-5, Green())))
Try like this
=If(cost > 0, Green(),
if(cost >= 0 AND cost <= -5, Yellow(),
if(cost < - 5, Green())))
Here is a condition for your RGB Colors, please use
=If(Cost > 0, Red(), If(Cost < (-5), Green(), Yellow()))