# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## Using string with hyphen in it

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!

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: Using string with hyphen in it

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)

)

)

)

5 Replies
New Contributor II

## Re: Using string with hyphen in it

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)

)

)

)

Valued Contributor

## Re: Using string with hyphen in it

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

MVP

## Re: Using string with hyphen in it

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)

)

)

)

New Contributor II

## Re: Using string with hyphen in it

Thanks Petter - that seems to have worked!

I thought the age bands were string, but turns out they were numbers!

New Contributor II

## Re: Using string with hyphen in it

Thanks Sebastian - I hadn't realised that my age variable was actually number and not string.