Coloring by expression

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

I have a bar graph and when the percentage is over 95% the color should be blue, and if it is under 95% it should be red.

It has been working until I figured out I need to convert the time zone.

I created a variable to get yesterdays percentage called "vAttend"

the formula that has been working:

vAttend = Sum({$<Date_Emp={"$(=FirstWorkDate(Today()-1,1,$(vHolidays)))"}>} (Actual_Emp / FTE_Emp))

when I try to convert to a different time zone, it doesn't work

Sum({$<Date_Emp={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00')-1,1,$(vHolidays)))"}>} (Actual_Emp / FTE_Emp))

Here is the expression for the colors I am using.

=if($(vAttend) < 0.95, 'rgb(204, 0, 0)', 'rgb(68,119,170)')

Any ideas how to fix?

Re: Coloring by expression

Nagaraju_KCS — Fri, 21 Jul 2017 14:23:53 GMT

Remove Quotes, that should work

=if($(vAttend) < 0.95, rgb(204, 0, 0), rgb(68,119,170))

joshrussin — Fri, 21 Jul 2017 14:51:29 GMT

that worked, but I also had to put a parenthesis around the entire vAttend equation for some reason. Qlik is very sensitive.