Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Re: Conditional Format Date Range

Why did you include, Round(), and further, when I applied the formula to my chart, it came out as follows as all red, with the green bar as grey.

Highlighted
Not applicable

Re: Conditional Format Date Range

Never mind, I fixed it as follows:

=
IF(
Sum({$<[Metric]={'Direct Revenue'}, DATE={">=$(=today(DATE)) <=$(=Max(DATE))"}>}[Act/Fcst]), rgb(128, 128, 128),

IF(
(
Sum({$<[Metric]={'Direct Revenue'}, DATE={">=$(=Min(DATE)) <$(=today(DATE))"}>}[Act/Fcst]) -
Sum({1<[Metric]={'Direct Revenue'}, DATE={">=$(=Min(DATE)) <$(=today(DATE))"}>}[Plan])) < 0,rgb(219,60,36),

IF(
(
Sum({$<[Metric]={'Direct Revenue'}, DATE={">=$(=Min(DATE)) <$(=today(DATE))"}>}[Act/Fcst]) -
Sum({1<[Metric]={'Direct Revenue'}, DATE={">=$(=Min(DATE)) <$(=today(DATE))"}>}[Plan])) >= 0,Green())))

Community Browser