Why variance cell not change to red ?

paulyeo11 · ‎2017-05-12

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 · ‎2017-05-12

my QVF

Anonymous · ‎2017-05-12

Take the SUM out :

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

paulyeo11 · ‎2017-05-12

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 · ‎2017-05-12

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

paulyeo11 · ‎2017-05-12

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