Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Bar Chart Full Accumulation Colour Background Expression

Hi Guys

I have a bar chart with full accumulation.  Syntax below.  How do I colour the bars that have reached the budget. So if the 22nd have exceeded the 79,425,022, I would like the bar to be Green().

Expression:

Sum({<Type={'J'},Date={'>=$(vFYPeriod)<=$(vToday)'},DI_Period=>} Value)

// J indicates a job, and vFYPeriod is the start of the month.