topic Help with formula - Background Color in QlikView

Help with formula - Background Color

ivandrago — Thu, 29 Jul 2010 10:35:03 GMT

Hi,

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

([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

Help with formula - Background Color

Anonymous — Thu, 29 Jul 2010 10:43:34 GMT

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 '-')

Help with formula - Background Color

ivandrago — Thu, 29 Jul 2010 10:56:10 GMT

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

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

Help with formula - Background Color

ivandrago — Thu, 29 Jul 2010 11:02:48 GMT

Yeah it is showing as 0.41666666666667

Help with formula - Background Color

ivandrago — Thu, 29 Jul 2010 11:38:24 GMT

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

Thanks Ivan

Help with formula - Background Color

Anonymous — Fri, 30 Jul 2010 07:04:37 GMT

Ivan,

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