# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Not applicable

## Total Employee

Dear All, iam newbie on Qklikview

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

1 Solution

Accepted Solutions
MVP

Hi

Calculating rolling n-period totals, averages or other aggregations

Thanks & Regards,
Mayil Vahanan R
10 Replies
Specialist

dimension - Year

Expression sum(Joint_Employee)

Not applicable
Author

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

MVP

Let me have clarification on

2001|40

means in Year 2001, 40 new employee joined?

if yes,

use below script...

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

Not applicable
Author

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

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_employeepeek([Employee total], -1)+Joint_employee) as[Employee total]

Hope this helps

Not applicable
Author

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

MVP

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

Thanks & Regards,
Mayil Vahanan R
Not applicable
Author

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

MVP

Hi