topic Re: Help on RGB Colors? in QlikView

Help on RGB Colors?

Fri, 20 Mar 2015 09:16:02 GMT

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')

awhitfield — Fri, 20 Mar 2015 09:19:57 GMT

Just use Red() and Green()

Andy

Fri, 20 Mar 2015 09:20:22 GMT

Hi,

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

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

PrashantSangle — Fri, 20 Mar 2015 09:21:49 GMT

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

Fri, 20 Mar 2015 09:21:50 GMT

Hi,

Same you have done in button also.

Regards

Vimlesh

rajkumarb — Fri, 20 Mar 2015 09:36:41 GMT

HI Murali

this may help

Fri, 20 Mar 2015 09:39:30 GMT

Thank you Raj 🙂 Very Good example.

buzzy996 — Fri, 20 Mar 2015 10:28:53 GMT

use max dreamer solution tht helps.