topic Re: Attendance Portal in QlikView

Attendance Portal

noman212 — Fri, 13 Jun 2014 06:37:36 GMT

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.

Re: Attendance Portal

sujeetsingh — Fri, 13 Jun 2014 06:56:39 GMT

Use interval function man

Re: Attendance Portal

Anonymous — Fri, 13 Jun 2014 06:59:38 GMT

Hi,

Please find the attachment. might help you ..

Re: Attendance Portal

noman212 — Fri, 13 Jun 2014 07:08:50 GMT

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.

Re: Attendance Portal

Anonymous — Fri, 13 Jun 2014 07:20:27 GMT

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

Re: Attendance Portal

noman212 — Fri, 13 Jun 2014 07:51:04 GMT

thats work perfect

thanks alot