topic Re: Employee Opening and closing count required as per attached EMP.XLS file in QlikView

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

vikasmahajan — Thu, 22 Jan 2015 06:02:25 GMT

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

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

ashfaq_haseeb — Thu, 22 Jan 2015 06:16:07 GMT

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

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

robert_mika — Thu, 22 Jan 2015 06:26:45 GMT

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

Does the blue color in the table have any meaning?

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

vikasmahajan — Thu, 22 Jan 2015 06:33:11 GMT

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

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

vikasmahajan — Thu, 22 Jan 2015 06:38:19 GMT

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

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

robert_mika — Thu, 22 Jan 2015 06:38:42 GMT

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

Opening

Joinies

Resignies

Closing

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

vikasmahajan — Thu, 22 Jan 2015 06:41:47 GMT

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

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

vikasmahajan — Thu, 22 Jan 2015 07:06:37 GMT

Dear Robert

Do you require more information ???

Vikas

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

vikasmahajan — Thu, 22 Jan 2015 07:09:03 GMT

Dear Ashfaq

Do you require more information ???

Vikas

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

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

vikasmahajan — Thu, 22 Jan 2015 10:24:01 GMT

Did you working on the same ???

Thanks

Vikas

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

vikasmahajan — Wed, 28 Jan 2015 03:54:36 GMT

Dear Sir

Have you got solution for the same

Vikas