Discussion board where members can get started with Qlik Sense.
I'm trying to set colours on a chart using the following expression:
IF(Age = '<25',
IF (Age = '25-34',
IF (Age = '35-50',
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?
Go to Solution.
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 ,
If( Agr >= 25 AND Age <=34 ,
If( Age >= 35 and Age <= 50,
i fthe hyphen is part of the string try the following:
IF (Age = "'25-34'",
IF (Age = "'35-50'",
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.
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.