Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use Greater and less than function in Qlikview

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

14 Replies
Not applicable
Author

Hi

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

Anonymous
Not applicable
Author

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

Not applicable
Author

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

Anonymous
Not applicable
Author

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

Not applicable
Author

Hi

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

Thanks for all the help.