Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
rodman2211
Contributor
Contributor

Conditional Colors positive and negative variance values

Hello,

I wonder if someone could help as I've given up with this one after hours playing with it.

I'm trying to have a tables shoe red values if a variance percentage value is above 25% or below -25%.

I've tried with the following example without success:

if($(hotel_spend_avg_ytd_yoy)<-0.25,RGB (170,57,57),RGB(87,149,50)),

if($(hotel_spend_avg_ytd_yoy)>0.25,RGB(170,57,57),RGB(87,149,50))

When I try either of those individually they work with the expected behavior just fine. When stringed together the formula says "OK" but neither color appear.

Any insight/help you can provide me with will be greatly appreciated!

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

try this one

if($(hotel_spend_avg_ytd_yoy)<-0.25 or $(hotel_spend_avg_ytd_yoy)>0.25,RGB (170,57,57),RGB(87,149,50))

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

try this one

if($(hotel_spend_avg_ytd_yoy)<-0.25 or $(hotel_spend_avg_ytd_yoy)>0.25,RGB (170,57,57),RGB(87,149,50))

rodman2211
Contributor
Contributor
Author

Thank you SO MUCH! It was "or"!!!! arrrrghhh.

Thanks again my friend,

Rod