Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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])
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
i think that the Problem is the timeformat. Qlikview is very severe with that
Hi
I changed the time format in sql server to HH:MM:SS and now its working fine.
Thanks for all the help.