topic Expressions , change Background colour based on range in QlikView

Expressions , change Background colour based on range

Fri, 22 Jul 2011 14:16:25 GMT

Hi guys

I have bar chart and I want the colour of the bars to change, dependant on the value.

So on the expressions tab, in Background colour if result is Less that 45, Orange, BETWEEN 45 and 50 go Green and greater than 50 go red.

I have tried the below, and it does not go red at all.

Can anyone see where my issue lies?

Thanks

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<45, RGB(255,128,0),

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])>45, RGB(0,191,0),

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<50, RGB(0,191,0),

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])>50, RGB (255,0,0)))))

danielrozental — Fri, 22 Jul 2011 14:21:32 GMT

Try

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<45, RGB(255,128,0),

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<50, RGB(0,191,0), RGB (255,0,0)))

Fri, 22 Jul 2011 14:54:24 GMT

Thanks Daniel