Help with formula - Background Color - Qlik Community

ivandrago · ‎2010-07-29

Hi,

I have the following formula, which does not seem to be woking:

If

([Arrive Time] >= MakeTime(00,00) AND [Arrive Time] <= MakeTime(09,45),RGB(0,255,0))

Basically want the field to go green if the [Arrive Time] is between 00:00 and 09:45

Or if anyone can think of a variable that would set this in the script

Thanks

Anonymous · ‎2010-07-29

Is your [Arrive Time] field a proper numerical time value or is it a string value?

(Easily checked by selecting one [Arrive Time] value and adding a text object with =num([Arrive Time]) and it should return a decimal value and not a '-')

ivandrago · ‎2010-07-29

The [Arrive Time] is worked out within the script by doing the following:

Mid(ArriveDttm,12,5) as [Arrive Time]

ivandrago · ‎2010-07-29

Yeah it is showing as 0.41666666666667

ivandrago · ‎2010-07-29

Johannes, have you any suggestions on what to do for this?

Thanks Ivan

Anonymous · ‎2010-07-30

Ivan,

Attach an example document and someone will figure it out for you quickly