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: 
noman212
Creator III
Creator III

Set analysis calculating late timings of employee

Hello

i want to calculate the time difference i have excel sheet in which DATE field display time as 1/2/1900  9:06:00 AM, i just want to calculate late timing if time of emp exceed 9:15 then it count the time difference that how much emp late today.

pls help

thanks

1 Reply
Gysbert_Wassenaar

EmployeeArrivals:

Load *, if(IsLate, interval(Time - 925/2400,'hh:mm') as TimeLate ;

Load *, if(Time>925/2400,1,0) as IsLate ;

Load EmployeeID, DATE From myexcelfile.xlsx (oomxl, ...etc);

Expressions for use in charts:

sum(TimeLate)

count({<IsLate={1}>}EmployeeID)


talk is cheap, supply exceeds demand