Colour Bar Chart Dependent on TIME total

[racer25]

Hi

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]

Check this?

[racer25]

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 · Accepted solution]

try this as colour-expression:

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

hope this helps

[racer25]

That worked - thanks.

Clearly needed the time format to match if question.