topic If value is between 2 numbers then color x in App Development

If value is between 2 numbers then color x

JBritten — Mon, 20 Dec 2021 21:02:46 GMT

Need a little help

We are trying to write a color expression for the following traffic light table:

If cop_overall_status is between 0-39 = Green

If cop_overall_status is between 40-89 =Yellow

If cop_overall_status is between 90-100 = Light Red

If cop_overall_status value equals 0 = Light grey

This is what I thought it would look like however I get an Error message in QLIK

=if([cop_overall_status]={">=1 <=39"},Green(),if([cop_overall_status]={">=40 <=89"},Yellow(),if([cop_overall_status]={">=90 <=100"},LightRed(),if([cop_overall_status]=0,lightGray()))))

Thanks

Re: If value is between 2 numbers then color x

rubenmarin — Sat, 27 Mar 2021 08:13:53 GMT

Hi, thats not hte corect syntax for if(), try as

=if([cop_overall_status]>=1 and [cop_overall_status]<=39,Green() ,if([cop_overall_status]>=40 and [cop_overall_status]<=89,Yellow() ,if([cop_overall_status]>=90 and [cop_overall_status]<=100,LightRed() ,if([cop_overall_status]=0,lightGray()) )))

Re: If value is between 2 numbers then color x

JBritten — Mon, 29 Mar 2021 12:12:29 GMT

Thank you that worked