topic Background colorization using IF AND in QlikView

Background colorization using IF AND

qlik88 — Wed, 01 Mar 2023 19:29:26 GMT

Hello,

I am trying to write a function that would do background colorization, for example:

1. If the attribute value is more than 0.98, color the cells red

2. If the attribute value is more than 0.85 and less than 0.98, color the cells orange

I wrote this:

if([attribute] > 0.85 and [attribute] < 0.98,'orange', if([attribute] > 0.98, 'red', 'white'))

The first part of the function to color the cells orange is not working, I am only getting red color. I made some tests and basically Qlik is not taking into account my function when I write "AND".

Does someone have any idea how to do it? Should be simple but I couldn't find an answer online.

Thanks in advance!

Re: Background colorization using IF AND

sarafoster — Fri, 03 Mar 2023 04:58:50 GMT

It seems that the issue may be related to the syntax used in your function. In Qlik, the correct syntax for using the logical operator AND is to use the symbol "&" instead of "and". HomeBargains.co.uk

Try updating your function to the following:

if([attribute] > 0.85 & [attribute] < 0.98,'orange', if([attribute] > 0.98, 'red', 'white'))

This should properly evaluate the logical operator AND and apply the orange color to cells where the attribute value is between 0.85 and 0.98.