Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Color is not shown correctly!!

Hello,

I have attached a samplpe of application. In that i am using expression to color the values above and below threshhold as RED.

And in between threshhold as BLACK.

=if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) <  (Avg(Price) - Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02) , RGB(0,0,0),

)))

But same is not happening . Please see...

1 Solution

Accepted Solutions
17 Replies
salto
Specialist II
Specialist II

Hello Nikhil,

RGB is working well. I think that the problem is that the condition

if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02)


is never TRUE and that is the reason why it does not show black.


Hth.

PrashantSangle

Hi,

Try this

=if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) <  (Avg(Price) - Avg(Price)*0.02) , RGB(255,0,0), RGB(0,0,0),

))

Remove this condition

if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02),

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
nikhilgarg
Specialist II
Specialist II
Author

Hey,

it is also not working.

What should i do ??

Thanks

antoniotiman
Master III
Master III

Hi NiKhil,

I correct espression [- ',' + 2')'], but I don't know if it work well. I see only red.

Regards

nikhilgarg
Specialist II
Specialist II
Author

I cannot open your qvw.Can you tell me here.

Thanx

antoniotiman
Master III
Master III

Img.png

sorrakis01
Specialist
Specialist

Yes,

the example of Antonio works well.

=if((Sum(Price) > (Avg(Price) + Avg(Price)*0.02)) , RGB(10,410,0), if(Sum(Price) <  (Avg(Price) - Avg(Price)*0.02) , RGB(25,80,100),

if(Sum(Price) >= (Avg(Price) - Avg(Price)*0.02) and Sum(Price) >= (Avg(Price) + Avg(Price)*0.02), RGB(0,255,80)

)))

I changed the values of RGB to demostrate it

Regards

JAG

PrashantSangle

Hi,

There is bracket missing in your expression.

You can correct your expression by giving proper bracket closing

Try Like

=if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) < (Avg(Price) - Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02)) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02)) , RGB(0,0,0),

)))

or modify it like

=if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02)) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02)),RGB(0,0,0),
if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02),RGB(255,0,0),
if(Sum(Price) <  (Avg(Price) - Avg(Price)*0.02) , RGB(255,255,255),
)))

or

you can try this also

=if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02) , RGB(255,0,0),
if(Sum(Price) <  (Avg(Price) - Avg(Price)*0.02) , RGB(255,255,255), RGB(0,0,0)
))

and check your logic which you are comparing in if. I am not sure that it is working proper.

Kind Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
nikhilgarg
Specialist II
Specialist II
Author

HEy,

It is still not working. I mean ,  I want the values above High threshhold and below Low threshhold as RED and between High threshhold and LowThreshhold as BLACK. PRice is my field.

How to do this ???