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: 
Not applicable

Help on RGB Colors?

see the below exp and i need 'TOP' is Green color and 'Bottom' is Red color. Need Help?

=if([Avg $ Parts/UsedCars] >= 1500, 'TOP',  'Bottom')

1 Solution

Accepted Solutions
PrashantSangle

Hi,

If you are writting this in expression tab->

then click on + symbol -> Text Color/ BackGroud Color

write-> if([Avg $ Parts/UsedCars] >= 1500, Green(),Red())

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 🙂

View solution in original post

7 Replies
awhitfield
Partner - Champion
Partner - Champion

Just use Red() and Green()

Andy

Not applicable
Author


Hi,

Go to expression->open +->put condition here

if([Avg $ Parts/UsedCars] >= 1500, 'TOP',  'Bottom')

PrashantSangle

Hi,

If you are writting this in expression tab->

then click on + symbol -> Text Color/ BackGroud Color

write-> if([Avg $ Parts/UsedCars] >= 1500, Green(),Red())

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 🙂
Not applicable
Author

Hi,

Same you have done in button also.

Regards

Vimlesh

rajkumarb
Creator II
Creator II

HI Murali

this may help

Not applicable
Author

Thank you Raj 🙂 Very Good example.

buzzy996
Master II
Master II

use max dreamer solution tht helps.