0 Replies Latest reply: Jan 31, 2015 10:53 AM by vikas mahajan RSS

    Calculation of Employee Head Count - (Opn+Gross Additions-Resign=Closing)

    vikas mahajan

      Dear All

       

      I have requirement of count of employee I have DOJ (Date of Joins) and Date of Resign (DOL) 2 files with Sample Employee Master

      Following view is to develop in Qlikview

       

      Dimensions ( Month/Qtr/Year) as per selections head count will be closing as opening like customer ledger opening and closing is to be calculated. DOL with null records are active and those who have left company have DOL.

       

      Also attaching Community Attrition Qvw Same Concept I want.

       

      Please Can anyone give solution When I select year / Qtr / Month Head count is not coming proper

      2013-2014 total 10 employee ( 10 - 2 ) = 8 is net head count. when i select period 13-14  emp is showing

      6 but actual head count is 8

       

       

      Vikas