topic Re: compare time instruction IF in QlikView

compare time instruction IF

Mon, 26 Jan 2026 18:19:17 GMT

Hello
I am new to the forum, I need help, I have a table of two fields name and arrival time, I will wish to display all persons arriving from 7am: 45 red and one in green.

example

Header 1	Header 2
pat	05:45
nav	07:00
be	07:45
Hugues	10:50

but I do not know how to put in my expression
But I thought the If...Then...Else Statement,
rgb(255,255,255), rgb(0,255,0),hour(7),minute(45)

Re: compare time instruction IF

swuehl — Sat, 26 Oct 2013 10:23:01 GMT

First, make sure that you've read in the time field correctly:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

Then, you can create a straight table chart with field 'name' as dimension and

=only([arrival time])

as expression, assuming one arrival time per name value.

Then you've got two options for colour the expression:

Either use the old-style visual cues tab in chart properties, and enter an expression like

maketime(7,45)

in the entry field for upper and lower limit (chosing an appropriate colour also).

Or, second option, use a Text Color attribute expression in expression tab:

Expression could look like

=if( [arrival time] >= maketime(7,45), lightred(), lightgreen() )

Re: compare time instruction IF

Sat, 26 Oct 2013 10:42:08 GMT

Thank swuehl you it works