Null Values not recognizing as number

NickBentley — Fri, 30 Jul 2021 05:07:43 GMT

Hi all,

I have straight table where I want to highlight values greater than 75% in green and less than 75% in red.

I am achieving this by adding an if statement to the end of the expression within the Background Colour option.

if((sum({<[Difot Week Start Date]={"29/06/2020"} >}[Difot Units Received]))

/
(sum({<[Difot Week Start Date]={"29/06/2020"} >}[Difot Units Ordered]))<=.75 ,RGB(255,196,196),RGB(185,255,185))

However, in the cases where the expression results in null the null value is returning green and not red as I wish. Even when I convert the null to zero, it is still displaying green.

Appreciate any advice on how to solve this.

Thanks,

Nick

Re: Null Values not recognizing as number

tresB — Fri, 30 Jul 2021 05:19:18 GMT

So basically you have to put your red condition in else part of the expression. Tyr like:

If( Expr >75, green, red)

Re: Null Values not recognizing as number

NickBentley — Fri, 30 Jul 2021 10:48:23 GMT

Thanks Tresesco! That has worked well.

Cheers,

Nick

topic Null Values not recognizing as number in QlikView

Null Values not recognizing as number

Re: Null Values not recognizing as number

Re: Null Values not recognizing as number