5 Replies Latest reply: Oct 7, 2015 8:53 AM by Digvijay Singh RSS

    How to find no of employees entering late by interval

      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

      Here the employee usual timing is 9:00 AM