topic Re: Total Employee in QlikView

Total Employee

Thu, 11 Sep 2014 10:09:36 GMT

Dear All, iam newbie on Qklikview

please help me,

current condition i have data

year |Joint_employee

1998|10

1999|20

2000|30

2001|40

2002|50

2003|60

2004|70

2005|80

2006|90

so , i want to know total employee by year , if click year 2005 then display right total employee (output)

thanks

Re: Total Employee

AbhijitBansode — Thu, 11 Sep 2014 10:16:15 GMT

dimension - Year

Expression sum(Joint_Employee)

in your chart

Re: Total Employee

Thu, 11 Sep 2014 10:19:45 GMT

Hi,

You can use list box in general where you will have list boxes for both your variables and as in you choose the year, the corresponding Joint_employee will be shown.

Hope this helps

Re: Total Employee

MK_QSL — Thu, 11 Sep 2014 10:26:02 GMT

Let me have clarification on

2001|40

means in Year 2001, 40 new employee joined?

if yes,

use below script...

Load

SubField(Field,'|',1) as Year,

SubField(Field,'|',2) as Joint_employee

Inline

[

Field

1998|10

1999|20

2000|30

2001|40

2002|50

2003|60

2004|70

2005|80

2006|90

];

Now create a list box for Year

and below expression in text box...

=SUM({<Year = {'<=$(=Max(Year))'}>}Joint_employee)

Select Year as per your choice and you will get total employees for that year...

Re: Total Employee

Thu, 11 Sep 2014 10:52:03 GMT

If that is the case which Manish mentioned above, you can use the load statement as he said,

Load

SubField(Field,'|',1) as Year,

SubField(Field,'|',2) as Joint_employee

Inline

[

Field

1998|10

1999|20

2000|30

2001|40

2002|50

2003|60

2004|70

2005|80

2006|90

];

and also add another field here which will give you total employee till the respective years and it can be done by,

If(rowno()=1, Joint_employee, peek([Employee total], -1)+Joint_employee) as[Employee total]

Hope this helps

Re: Total Employee

Mon, 15 Sep 2014 03:26:55 GMT

sorry, original data from mysql, ( i connect with mysql server)

i have filed

idemp , name, join_date, terminate_date, status

----------------------------------------------------------------------

1 a1 2000/09/09 2011/09/09 In-Active

2 a2 2001/09/12 Active

3 a3 2002/09/09 Active

4 a4 2003/09/09 Active

5 a5 2004/09/09 Active

n an 2014/09/13 Active

i want know

1. sum employee hired

2. turn over employee every year

3. total employee every year

thanks four your help

Re: Total Employee

MayilVahanan — Mon, 15 Sep 2014 03:53:10 GMT

Try like this

Create the year field based on joining date. and use year field as dimension.

Exp:

1. Count(idemp) -- Sum of employee hired

2. From ur example data, there is no information for turn over.. May be something like this

Sum(turnover)

3. Count({<status = {'Active'}>}idemp) - total employee every year.

Hope it helps

Re: Total Employee

Mon, 15 Sep 2014 04:14:50 GMT

Thanks for your attention

For number 3,

If I want to know total employee cumulative ( not by year)

Ex , employee active

2001=20 prs

2002=30 prs

So in end of 2002 I have total employee cumulative 50, do yu have any solution aboit it

Thanks

Re: Total Employee

MayilVahanan — Mon, 15 Sep 2014 05:09:04 GMT

Please refer this link for cumulative

Calculating rolling n-period totals, averages or other aggregations

Re: Total Employee

Wed, 17 Sep 2014 04:12:30 GMT

thanks very much

Re: Total Employee

MayilVahanan — Wed, 17 Sep 2014 05:13:14 GMT

Please close the thread