Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
satyadev_j
Specialist
Specialist

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

venkatasreekant
Specialist
Specialist

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.

satyadev_j
Specialist
Specialist

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

noman212
Creator III
Creator III
Author

thats work perfect

thanks alot