topic Re: Worked hours in QlikView

Worked hours

Tue, 23 Feb 2016 22:11:57 GMT

Hi,

I have the same problem as some other have had here in the community but I can't get the suggested solutions to work. I want to calculate the number of hours worked each day. It works just fine if they have clocked in and out ONCE a day. But when someone clocks in and out more than ONCE, it breaks.

Please see attached file. I have selected an employee that has clocked in twice ion the 7th of January. I would like the calculation to be presented in the pivot chart on the left called "CALCULATION".

Thanks in advance - I'm thankful for suggestions!

Re: Worked hours

tamilarasu — Wed, 24 Feb 2016 03:46:18 GMT

Hi Daniel,

Check the attachment.

Clock In Expression:

Time(Min(ReportingTimeIn),'hh:mm:ss')

Clock Out Expression:

Time(Max(ReportingTimeOut),'hh:mm:ss')

Re: Worked hours

jagan — Wed, 24 Feb 2016 04:16:16 GMT

Hi,

Just use

Clock In =Max(ReportingTimeIn)

Clock Out= Max(ReportingTimeOut)

and in Number tab select Time for this two expressions.

Hope this helps you.

Regards,

Jagan.

Re: Worked hours

HirisH_V7 — Wed, 24 Feb 2016 04:57:55 GMT

Hi,

Check this,

In Time
Time(Aggr(Min(ReportingTimeIn),prv.Person,ReportingDate),'hh:mm:ss') 

Out Time
Time(Aggr(Max(ReportingTimeOut),prv.Person,ReportingDate),'hh:mm:ss')

Time Reported
TIME([Clock out]-[Clock in],'hh:mm:ss')

Hope this helps,

Regards,

PFA,

Hirish

Re: Worked hours

Mon, 14 Mar 2016 12:53:04 GMT

Hi, Thanks for you response.

Doing it as you describe, I will get a summary from start time to end time. If a person clocks in and out for the first time

06:49:00

16:05:00

09:16:00

and then clock in for the second time:

19:52:00

20:45:00

00:53:00

The aggregated time will be 10:09 hours/min and not 13:56 as I understands your solution shows.

Any ideas in how to fix it?

Thanks in advance.

Daniel

Re: Worked hours

jagan — Tue, 15 Mar 2016 01:04:23 GMT

Hi,

Calculate the difference of TimeOUt and Timein in script and just sum up the difference in the chart.

Hope this helps you.

Regards,

jagan.

Re: Worked hours

Sat, 19 Mar 2016 06:25:29 GMT

Hi,

I think I already do that, but it shows the wrong summary as I mentioned aboove.

if(AttRRepType=3, Time("AttrRepDt_Time"),null()) as ReportingTimeOut,

if(AttRRepType=1, Time("AttrRepDt_Time"),null()) as ReportingTimeIn,