Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Valued Contributor II

Why variance cell not change to red ?

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

1 Solution

Accepted Solutions

Re: Why variance cell not change to red ?

Take the SUM out :

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

5 Replies
paulyeo11
Valued Contributor II

Re: Why variance cell not change to red ?

my QVF

Re: Why variance cell not change to red ?

Take the SUM out :

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

paulyeo11
Valued Contributor II

Re: Why variance cell not change to red ?

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>

Re: Why variance cell not change to red ?

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

paulyeo11
Valued Contributor II

Re: Why variance cell not change to red ?

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