Qlik Community

Qlik Sense App Development

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

paulyeo11
Valued Contributor II

How to make it display red when -ve and Green when +ve ?

Hi All

I want to make the text color display red when the value is -ve and green color when +ve.

I have place the below expression at condition color   :-

if($(vSalesVariance) >0 ,'#46C646','#d01919')

expression color.png

But the color does not change. Hope some one can advise me where i go wrong ?

Paul

1 Solution

Accepted Solutions

Re: How to make it display red when -ve and Green when +ve ?

Check it out now

15 Replies
paulyeo11
Valued Contributor II

Re: How to make it display red when -ve and Green when +ve ?

qvf

Re: How to make it display red when -ve and Green when +ve ?

May be try with RGB()

If($(vSalesVariance) >0 , RGB(70, 198, 70), RGB(208, 25, 25))

paulyeo11
Valued Contributor II

Re: How to make it display red when -ve and Green when +ve ?

Hi Sunny

I have try , but the text color never change .

Paul

Re: How to make it display red when -ve and Green when +ve ?

It seems that you are using an extension? Is that true? I won't be of much help if that is true

paulyeo11
Valued Contributor II

Re: How to make it display red when -ve and Green when +ve ?

Hi Sunny

I am not using extension.

Paul

Re: How to make it display red when -ve and Green when +ve ?

Can you point out which object are you trying this on?

paulyeo11
Valued Contributor II

Re: How to make it display red when -ve and Green when +ve ?

Hi sunny

negative.png

Re: How to make it display red when -ve and Green when +ve ?

Those button seems to be using extension because I am unable to view those buttons

paulyeo11
Valued Contributor II

Re: How to make it display red when -ve and Green when +ve ?

Hi Sunny

Yes i use extension , that is 2 button for select field value . to make the value display +ve and -ve.

By the why , Can you make the 15.3 change from black to Green ?

Paul

Community Browser