topic Re: Colour Bar Chart Dependent on TIME total in QlikView

Colour Bar Chart Dependent on TIME total

racer25 — Tue, 13 Jun 2017 09:46:10 GMT

I am tried to colour code the bar's on bar chart based on total time ( and as posting here without success ).

I have in the Background Colour entered;

=if(Interval(sum(Time)) >= 7.5, RGB (243, 193,68), RGB(42, 194,231))

I have had this feature working before in the past where it was numerical rather than time based calculations.

I have attached a mock-up with Wednesday and Thursday to be Blue and other days to be Amber.

I'd appreciate some help on getting working.

Thanks,

Rob

Anil_Babu_Samineni — Tue, 13 Jun 2017 09:59:47 GMT

Check this?

racer25 — Tue, 13 Jun 2017 10:32:50 GMT

That is what should happen.

I have opened your file on both my own copy of Qlikview v12 and our Server install 11.2 and when opening your file and still get all blue.

Frank_Hartmann — Tue, 13 Jun 2017 12:06:28 GMT

try this as colour-expression:

=if(Interval(Time) >= '07:30', RGB (243, 193,68), RGB(42, 194,231))

hope this helps

racer25 — Tue, 13 Jun 2017 12:20:57 GMT

That worked - thanks.

Clearly needed the time format to match if question.