Opening Head Count - Employees - URGENT Help required

[vikasmahajan]

Dear All,

I have empno , empname, doj,date_of_resign  fields

how i can show opening headcount/gross additions/attrition/closing head count

GRADE	Opening Headcount	Gross Additions	Attrition	Net Additions	Closing Headcount
ASSOCIATE	193	3	0	3	196
STAFF	74	3	0	3	77
SUPERVISOR	80	0	0	0	80
TRAINEE	32	1	1	0	32
WORKERS	95	0	0	0	95
Total	474	7	1	6	480

Please any one have idea please give guide lines also I want to calculate Attriation rate company level how I do this ?

Thanks in avanace

Vikas

[vikasmahajan]

I really appreciate your help Thanks.

Jose I really require when user select 2013-14  then closing head count of employee should match with Apr-2014-15

987 will be opening how to do this please give any idea ?

Vikas

[vikasmahajan]

hello

Can you please explain me how Tdata and Employee tables will be join which is common key  ?

// Join the tables

Join (T_Data)

LOAD * Resident Employees;

Vikas

[vikasmahajan]

I have attached emp.xls can you please create qvw and send me

Thanks

[salto]

Hello Vikas,

I see no attached file - however I cannot understand your requirements. CAn you please explain them a little bit more?

Regards.

[vikasmahajan]

Hii

Please see I have open new threat Head Count Analysis - Employee ( Opn + Gross Addtions -Resignations = Closing)

Requirement is when user select Year/Month/Qtr   following chart should display,  Suppose when user will select

Mar-2014  head count will be 480 , When user will select Apr-2014 so 480 will be in opening head count  like this I want to display in chart

GRADE	Opening   Headcount	Gross Additions	Attrition	Net Additions	Closing Headcount
ASSOCIATE	193	3	0	3	196
STAFF	74	3	0	3	77
SUPERVISOR	80	0	0	0	80
TRAINEE	32	1	1	0	32
WORKERS	95	0	0	0	95
Total	474	7	1	6	480

I have attached Emp excel file

Please can you create qvw n send me.

Thanks

Vikas

[vikasmahajan]

     Mr.Jose

  Following is requirement.               

  User Will SElect     Year/Qtr/Month  

    DOJ -> Date of joins and DOL -> Date of Leaving and S_Active -> Active/In-Active fields to be considered to       calculate this head count.

Let me know If you know more information.

Thank u very much.

Vikas

[salto]

Hi,

I have answered in the new thread.

[vikasmahajan]

Mr.Jonathan Can you give full script  Please help me

Vikas

[vikasmahajan]

I think this script will resolve my issue please help me to get desired result.

Vikas

[vikasmahajan]

//Load employee data

Employees:

LOAD grade,

  empno,

  empname,

  MonthStart(doj) As StartDate,

  MonthStart(date_of_resign) As EndDate

From .....

// Join the tables

Join (T_Data)

LOAD * Resident Employees;

1.   From.... ?????????? 

2.  Join which condition ?????

Vikas