Chart color by expression help

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

Hey everyone, having an issue here. For some reason, Qlik Sense Cloud is in GMT time and I have to convert it to retrieve the correct data after 7pm. I have fixed that issue. Just now I can't use color by expressions for some reason with the new expression.

Here is what worked

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

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

variable not defined in script

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

Here is what doesn't work

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

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

variable not defined in script

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

topic Chart color by expression help in QlikView

Chart color by expression help