Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kgraham25
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
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
sebastian_grah
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)

     )

     )

)

juraj_misina
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
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)

    )

  )

)

kgraham25
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!

kgraham25
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.

Community Browser