Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to set colours on a chart using the following expression:
IF(Age = '<25',
$(vRed),
IF (Age = '25-34',
$(vGreen),
IF (Age = '35-50',
$(vYellow),
$(vGrey)
)
)
)
For some reason I don't think it likes the hyphen in the string ('25-34'). Does anyone have any ideas on how to get around this?
Thanks!
There is no problem with a hyphen in a string like '25-34'.
Is your Age field a bucketed range already containing the literal strings '<25' , '25-34' , '35-50' ?
However if your Age field is a number indicating Age then you will have to do this:
If( Age <25 ,
$(vRed) ,
If( Agr >= 25 AND Age <=34 ,
$(vGreen),
If( Age >= 35 and Age <= 50,
$(vYellow),
$(vGray)
)
)
)
i fthe hyphen is part of the string try the following:
IF(Age ="'<25'",
$(vRed),
IF (Age = "'25-34'",
$(vGreen),
IF (Age = "'35-50'",
$(vYellow),
$(vGrey)
)
)
)
Hi Kelly,
can you be more specific on what happens or is not working? Hyphens in strings are perfectly OK, but you did not provide any problem description.
Juraj
There is no problem with a hyphen in a string like '25-34'.
Is your Age field a bucketed range already containing the literal strings '<25' , '25-34' , '35-50' ?
However if your Age field is a number indicating Age then you will have to do this:
If( Age <25 ,
$(vRed) ,
If( Agr >= 25 AND Age <=34 ,
$(vGreen),
If( Age >= 35 and Age <= 50,
$(vYellow),
$(vGray)
)
)
)
Thanks Petter - that seems to have worked!
I thought the age bands were string, but turns out they were numbers!
Thanks Sebastian - I hadn't realised that my age variable was actually number and not string.