Employee Opening and closing count required as per attached EMP.XLS file

[vikasmahajan]

Hii

In Qlikview I Want to create view like http://community.qlik.com/message/163026#163026

I am attaching EMP.XLS  which as DOJ (Date of join) and DOL (date of leaving) and s_active

for Active/In-Active.

Can you  give guide me how to achieve the same in Qlikview.

Vikas

[ashfaq_haseeb]

Hi,

Vikas can you explain a bit more on this?

What are the definitions of below things and how they are calculated

1) opening

2) Joinies

3) Resignies

4) Closing.

Is table shown above is what you are expecting?

In not provided the expected output.

Regards

ASHFAQ

[robert_mika]

Are you numbers from the table just random one or correlated to your data?

Does the blue color in the table have any meaning?

[vikasmahajan]

Hii,

Robert Thanks

1 Are you numbers from the table just random one or correlated to your data?

Ans  Dummy nos , Actual nos will come from EMP.XLS

2 Does the blue color in the table have any meaning?

Ans : No meaning it is appeared while copy from excel sheet.

Please provide me solution.

Vikas

[vikasmahajan]

Whene user will select  2013-14 Period ( 1-4-2013  to 31-3-2014)  fin year then

  opening < 1.4.2013

  Joinies  >=1.4.2013 to 31.3.2014  ( full fin year if selected year)

   Resignies  >=1.4.2013 to 31.3.2014  ( full fin year if selected year)

  Closing = Opening + Joinies - Resignies ( up to 31-3.2014)

When user will select  fin year 2014-2015  then closing of 31.3.2014 will be appeared in

opening head count. Logic will be same for Qtr / Month

Please tell me more information you required for the same

Vikas

[robert_mika]

Can you give real numbers for let say Grade "A1"

Opening

Joinies

Resignies

Closing

[vikasmahajan]

Dear Robert,

1.  EMP.XLS is attached from live data only emp names are changed to XYZ/PQR  like this  and actual grades are available in excel.

2. Whene user will select  2013-14 Period ( 1-4-2013  to 31-3-2014)  fin year then

  opening < 1.4.2013

  Joinies  >=1.4.2013 to 31.3.2014  ( full fin year if selected year)

   Resignies  >=1.4.2013 to 31.3.2014  ( full fin year if selected year)

  Closing = Opening + Joinies - Resignies ( up to 31-3.2014)

When user will select  fin year 2014-2015  then closing of 31.3.2014 will be appeared in

opening head count. Logic will be same for Qtr / Month

[vikasmahajan]

Dear Robert

Do you require more information ???

Vikas

[vikasmahajan]

Dear Ashfaq

Do you require more information ???

Vikas

Employee Opening and closing count required as per attached EMP.XLS file

[vikasmahajan]

Did you working on the same ???

Thanks

Vikas