topic Re: Break Time Calculation in QlikView

Break Time Calculation

kakani87 — Fri, 29 Dec 2017 04:46:29 GMT

Dear All,

I'm having employee data with me contains Name,In & Out Time, Date and a flag InOut 0 as In 1 as Out now i want to display the break time for every Out and In time calculation

let say i'm out on 01:30 pm and in on 02:00 pm so break time is 30 mins.

Can any one help me to achieve this.

Attached sample data for reference purpose

PFA.

Regards,

Kakani.

Re: Break Time Calculation

PrashantSangle — Fri, 29 Dec 2017 06:49:59 GMT

can you explain your sample data? provide required output w.r.t your data?

to find time / date difference you can use interval()

see below thread

Interval - script and chart function ‒ QlikView

Regards,

Prashant Sangle

Re: Break Time Calculation

kakani87 — Fri, 29 Dec 2017 09:04:05 GMT

Hi Prashant,

This is employee access details contains date , Name and access details like each and every swipe where InOut is a flag '0' entry is swipe in , flag '1' entry is swipeout

as follows.

now for emp chitra S out time is 11:12:18:AM ans In time is 11:30:06 AM break time of her is around 18 mins

my requirement is for every out and in of an employee should be displayed

Re: Break Time Calculation

pradosh_thakur — Fri, 29 Dec 2017 09:52:13 GMT

Like this

XsDetails:

LOAD tran_date,

EmpID,

EmpName,

InOut,

Time

FROM

Emp_XsDetails.xls

(biff, embedded labels, table is Sheet1$);

NoConcatenate

XsDetails1:

load * ,

if(Previous(EmpID)=EmpID and InOut =0,Interval(Time-PEEK(Time),'mm'),'N/A') as [break in mins]

Resident

XsDetails Order by tran_date,

EmpID,

EmpName,

Time;

drop Table XsDetails;

Re: Break Time Calculation

kakani87 — Fri, 29 Dec 2017 11:28:11 GMT

Thank you Pradosh for spending your valuable time to help me out of this scenario.