Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Calculating Employee Count based

Hi All ,

Requirement is need to get the count of Employee based on the shift start , End TIme and Break Time.

Input:

 

PS IDDate[Log Type][Start Time][End Time]
1236/1/2015LogIn/LogOff04/01/2015 05:00:00:00004/01/2015 15:00:00:000
1456/1/2015LogIn/LogOff04/01/2015 09:00:00:00004/01/2015 18:30:00:000
1786/1/2015LogIn/LogOff04/01/2015 13:00:00:00004/01/2015 21:00:00:000
1236/1/2015Break04/01/2015 08:00:00:00004/01/2015 8:30:00:000
1456/1/2015Break04/01/2015 11:00:00:00004/01/2015 11:15:00:000
1786/1/2015Break04/01/2015 17:00:00:00004/01/2015 17:30:00:000

Login/Logoff - > Shift start and end of each employee

Break  - > Break should be subtracted based on the start and End Time.

Expected Output :

IntervalCount
0 -10
1 -20
2-30
3-40
4-50
5-61
6-71
7-81
8-90.5
9-102
10-112
11-121.75
12-132
13-143
14-153
15-162
16-172
17-181.5
18-191.5
19-201
20-211
21-220
22-230
23-240

Regards,

Senthik

1 Reply
MVP
MVP

Re: Calculating Employee Count based

Hi,

Please find attached file for solution.

Regards,

jagan.

Community Browser