I have been asked to take over an existing qlikview document. It has an expression that is checking the value of a calculated field and colour coding the cell as Red or Green depending on the Target value :
if(isnull(Target)=0,
if($(vCalculatedNumber)>=Target,
RGB(140,255,140),
if($(vCalculatedNumber)< Target,
RGB(255,181,106),
RGB(255,100,100))), null())
I need to also test 'vCalculatedNumbe'r against a field called 'improvement' (which contains 'decrease' or 'increase'). Some measures are can be green if they are above target (increase) or below target (decrease).