topic If statement with 4 or more in QlikView

If statement with 4 or more

Mon, 25 Jun 2012 20:14:41 GMT

I'm not able to make one if more than three conditions, is how to color within the field of speech?

if(Goal = 'Green',Green(),

if(Goal = 'Yellow',Yellow(),

if(Goal = 'Red',Red(),

if(Goal = 'Gray',Darkgray()))))

Mon, 25 Jun 2012 20:35:10 GMT

Hi Gabriel,

May be you rae messing somewhere in braces cause

this expression worked 4 me

(count(XXX)=2100,green(),
(
if(count(XXX),Blue(),
(
if(count(XXX)=1500,Red(),
(
if(count(XXX)>1000,Black(),rgb(225,115,105)
)
))
))
)
)

thank you

Meher