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

Attendance Portal

i want to calculate late timings of employee i i tried but cant get correct values i attach my script file and excel sheet pls help.i wan to display Islate 1 if employee is late else 0 and in late timings i want to display how much late the employee is.

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi, Try below script,

Attendance:

LOAD *, If(Num(Time)>Num(Time#('9:15:00 AM','hh:mm:ss[.fff] TT')),1) as isLate

;

LOAD EMP.CODE,

     NAME,

     DEPARTMENT,

     DESIGNATION,

     [D A T E] as Date,

     [T ME IN],

     Time(Time#(Num(Hour([T ME IN]),'00')&Num(Minute([T ME IN]),'00')&Num(Second([T ME IN]),'00'), 'hhmmss')) as Time,

     ENT.TYPE

FROM

May 31, 2014.xls

(biff, embedded labels, header is 1 lines, table is [rptCUMTIMESHEETAll.rpt$]);

View solution in original post

5 Replies
sujeetsingh
Master III
Master III

Use interval function man

Anonymous
Not applicable

Hi,

Please find the attachment. might help you ..

noman212
Creator III
Creator III
Author

Thanks venkata for help , i want if time of employee time is greater than 9:15:00 AM then its show islate 1 and in time late difference in time.

Anonymous
Not applicable

Hi, Try below script,

Attendance:

LOAD *, If(Num(Time)>Num(Time#('9:15:00 AM','hh:mm:ss[.fff] TT')),1) as isLate

;

LOAD EMP.CODE,

     NAME,

     DEPARTMENT,

     DESIGNATION,

     [D A T E] as Date,

     [T ME IN],

     Time(Time#(Num(Hour([T ME IN]),'00')&Num(Minute([T ME IN]),'00')&Num(Second([T ME IN]),'00'), 'hhmmss')) as Time,

     ENT.TYPE

FROM

May 31, 2014.xls

(biff, embedded labels, header is 1 lines, table is [rptCUMTIMESHEETAll.rpt$]);

noman212
Creator III
Creator III
Author

thats work perfect

thanks alot