Traffic Light Conditional Statement

Fri, 01 Apr 2011 18:52:37 GMT

I am having trouble getting my traffic light to display colors properly based on an IF condition

I would like the light to turn green if the actual/budget is greater than 85% and red if it's below 75%. Below is what I tried to make work.

if((Sum([Amount Actual])/Sum([Amount Budget]))>=.85,1
if(Sum([Amount Actual]/sum([Amount Budget])<.75,3,2)

Comments please!!!

Anonymous — Fri, 01 Apr 2011 20:04:48 GMT

Can only check syntax, not the logic... You have two closing parenthesis missing (bold):

if((Sum([Amount Actual])/Sum([Amount Budget]))>=.85,1
if(Sum([Amount Actual])/sum([Amount Budget])<.75,3,2))

topic Traffic Light Conditional Statement in QlikView