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