topic Re: Use Greater and less than function in Qlikview in QlikView

Use Greater and less than function in Qlikview

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I am trying to create a chart for employees come to time and go on time.

One of the tables have columns name , IN_TIME ,OUT_TIME, DELAY

I want to write a expression for employees who are coming between 8 AM to 9 AM and going between 3 PM to 4 PM, They are coming on Time.

For IN_TIME >=8 and <=9 Comes early

OUT_TIME >=3 PM and 4 PM Going on time.

Please help me writing the expression and also assist me that which graph should i use for this.

Thanks

Re: Use Greater and less than function in Qlikview

Anonymous — Wed, 11 Nov 2015 08:01:47 GMT

try something like

Count({<IN_TIME={'>=8<=9)'},OUT_TIME={'>=3<=4'}>}

instead of numbers 8,9 etc. use your timeformat

Re: Use Greater and less than function in Qlikview

Kushal_Chawda — Wed, 11 Nov 2015 08:04:24 GMT

what is format of IN_TIME & OUT_TIME

Re: Use Greater and less than function in Qlikview

jonathandienst — Wed, 11 Nov 2015 08:08:10 GMT

Are the IN_TIME and OUT_TIME fields normal QV time fields (numeric, between 0 and 1 in value)? If they are, then the expression could be:

If(IN_TIME >= Time#('08:00') And IN_TIME <= Time#('09:00'), 'Comes early') As EarlyFlag,

If(OUT_TIME >= Time#('15:00') And OUT_TIME <= Time#('16:00'), 'Comes early') As EarlyFlag,

Note that Time#(08:00) is equivalent to the value 8/24, formatted as a time.

Re: Use Greater and less than function in Qlikview

Wed, 11 Nov 2015 08:42:29 GMT

I used the below expression but no output.

Count({<IN_TIME={">=1900-01-01 08:00:00.000<=1900-01-01 09:00:00.000"},OUT_IIME={"1900-01-01 15:00:00.000<=1900-01-01 16:00:00.000"}>} [IN_TIME])

I am using straight table.

It has 2 columns name , on_time

Time Format 1900-01-01 08:00:00.000

Please suggest

Re: Use Greater and less than function in Qlikview

Wed, 11 Nov 2015 09:46:42 GMT

Hi All,

Please help me on this

Re: Use Greater and less than function in Qlikview

Anonymous — Wed, 11 Nov 2015 10:07:07 GMT

for use in Expression you should provide a field only with timeformat

define in script:

time(IN_TIME,'hh:mm') as IN_TIME_H

time(OUT_TIME,'hh:mm') as OUT_TIME_H

then you can try the Expression

Count({<IN_TIME_H={">=$(=time('08:00'))<=$(=time('09:00')"},OUT_TIME_H={">=$(=time('15:00'))<=$(=time('16:00')"}>} [IN_TIME])

Re: Use Greater and less than function in Qlikview

Wed, 11 Nov 2015 10:26:16 GMT

not working..

Re: Use Greater and less than function in Qlikview

Anonymous — Wed, 11 Nov 2015 12:34:16 GMT

can you send example app?

Re: Use Greater and less than function in Qlikview

jonathandienst — Wed, 11 Nov 2015 12:53:52 GMT

Those should be Time#() fucntions:

Count({<IN_TIME_H={">=$(=time#('08:00'))<=$(=time#('09:00')"},OUT_TIME_H={">=$(=time#('15:00'))<=$(=time#('16:00')"}>} [IN_TIME])

,,,and this assume a 24 hour clock.If you are using a 12 hour clock, then use

time#('03:00pm')

..or specify the format

time#('15:00', 'hh:mm') or time#('03:00pm', 'hh:mmtt')

Re: Use Greater and less than function in Qlikview

Wed, 11 Nov 2015 12:54:37 GMT

First i was not getting any output i tried i again,

I am getting a below error.

Count({<IN_TIME_H={">=$(=time('08:00'))<=$(=time('09:00')"},OUT_TIME_H={">=$(=time('15:00'))<=$(=time('16:00')"}>} [IN_TIME])

error in set modifier ad hoc element list.I have attached the screenshot.

Thanks

Re: Use Greater and less than function in Qlikview

Anonymous — Wed, 11 Nov 2015 13:13:59 GMT

something was wrong with brackets

i tried this expresson and didnot get error message

=Count({<IN_TIME_H={">=$(=time('08:00'))<=$(=time('09:00'))"},OUT_TIME_H={">=$(=time('15:00'))<=$(=time('16:00'))"}>} [IN_TIME_H])

Re: Use Greater and less than function in Qlikview

Wed, 11 Nov 2015 13:32:24 GMT

Hi ,

Now i am not getting any error. but no output.

using the below.

=Count({<IN_TIME_H={">=$(=time('08:00'))<=$(=time('09:00'))"},OUT_TIME_H={">=$(=time('15:00'))<=$(=time('16:00'))"}>} [IN_TIME_H])

I guess the problem with IN_TIME data from sql server.

Thanks

Re: Use Greater and less than function in Qlikview

Anonymous — Wed, 11 Nov 2015 13:47:36 GMT

i think that the Problem is the timeformat. Qlikview is very severe with that

Re: Use Greater and less than function in Qlikview

Thu, 12 Nov 2015 11:58:31 GMT

I changed the time format in sql server to HH:MM:SS and now its working fine.

Thanks for all the help.