3 Replies Latest reply: May 28, 2018 8:12 AM by Shahzad Ahsan RSS

    Count Employees who are continuously absent for 10 days or more

    Shahzad Ahsan

      Hi Qlikers

      I need to count employees who are continuously absent for 10 or more days. Not included in weekends.

      The weekend days are Friday and Saturday

      Se the sample data, this should count as 1.

        

          

      EmpCodeEmpNameDateAbsent
      101A05/01/2018Y
      101A05/02/2018Y
      101A05/03/2018Y
      101A05/04/2018N
      101A05/05/2018N
      101A05/06/2018Y
      101A05/07/2018Y
      101A05/08/2018Y
      101A05/09/2018Y
      101A05/10/2018Y
      101A05/11/2018N
      101A05/12/2018N
      101A05/13/2018Y
      101A05/14/2018Y
      101A05/15/2018Y