Total Employee

[#1]

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

[AbhijitBansode]

dimension - Year

Expression sum(Joint_Employee)

in your chart

[#3]

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

[MK_QSL]

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...

[#5]

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

[#6]

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

[MayilVahanan]

Hi

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

[#8]

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

[MayilVahanan · Accepted solution]

Hi

Please refer this link for cumulative

Calculating rolling n-period totals, averages or other aggregations

[#10]

thanks very much