This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
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,
View solution in original post
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.