Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total Employee

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

1 Solution

Accepted Solutions
MayilVahanan

Hi

Please refer this link for cumulative

Calculating rolling n-period totals, averages or other aggregations

Thanks & Regards,
Mayil Vahanan R

View solution in original post

10 Replies
AbhijitBansode
Specialist
Specialist

dimension - Year

Expression sum(Joint_Employee)

in your chart


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

MK_QSL
MVP
MVP

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

Not applicable
Author

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

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

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

MayilVahanan

Hi

Please refer this link for cumulative

Calculating rolling n-period totals, averages or other aggregations

Thanks & Regards,
Mayil Vahanan R
Not applicable
Author

thanks very much