Why variance cell not change to red ?

[paulyeo11]

Hi All

I have a expression below :-

column(2) - column(1)

I need to make the black ground color change to red when the value is -ve.

So i create below expression :-

if((

SUM(

column(2) - column(1)

)

)<0,RED())

But the balck ground color does not change to red. Where go wrong ?

Paul Yeo

[paulyeo11]

my QVF

[Anonymous · Accepted solution]

Take the SUM out :

     if((column(2) - column(1))<0,RED())

[paulyeo11]

Hi Bill

Thank you very much it work.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[Anonymous]

If you have a Correct answer, then it is good etiquette to mark it as such to close the thread.

[paulyeo11]

Hi Bill

I am using the Qlik Community Mobile App.

I though i tick on the icon mean correct , which is wrong , i am sorry.

Paul