How to find Count of employees by late by interval

[#1]

Hi,Qlikers

i have emp Table:

Empid,Date,Timein

101,10/1/2015,9:00 AM

102,10/1/2015,9:10 AM

103,10/1/2015,9:05 AM

104,10/1/2015,9:20 AM

105,10/1/2015,9:40 AM

101,10/2/2015,9:15 AM

102,10/2/2015,8:45 AM

103,10/2/2015,9:25 AM

104,10/2/2015,9:35 AM

105,10/2/2015,9:40 AM

101,10/3/2015,9:01 AM

102,10/3/2015,8:55 AM

103,10/3/2015,9:25 AM

104,10/3/2015,9:22 AM

105,10/3/2015,9:45 AM

and

Table2:

LateBy

<5min,

5-10min

10-15min

15-20min

20-30min

>30min

if the user select a date and late by fields(i.e 10/1/2015 ,10-15min) then it has to show how many employees are late by 10-15 min on 10/1/2015

please send me the reply

Thanks in advanse

[vikasmahajan]

Hi,

Hey don't put duplicate issues in community , Community is Ideal for sharing knowledge,idea's , learning new things

hence request you to not post duplicate issues...

Vikas

[#3]

sorry for repeating

i will never repeat it again thanks for replying

[avinashelite]

Please mark the correct and helpful answers so that it will helpful for the others also

[#5]

Here i taken sample data but in my real data

by using the below code

DataInOut: 

LOAD *,

(Hour(Timestamp#(TimeIn,'HH:mm TT'))*60)+(Minute(Timestamp#(TimeIn,'HH:mm TT')))-540 as Late ;

LOAD EmpID,Date,

     Time(Min(TimeData),'HH:mm TT') as TimeIn,

     Time(Max(TimeData),'HH:mm TT') as TimeOut

Resident EmployeeTimeData

Group by  EmpID,Date;

here i am getting timein value but i am not getting Late value

like