topic Hires & Terminations in QlikView

Hires & Terminations

Fri, 17 Apr 2015 16:36:44 GMT

the following is my data model attached. I want to display the number of hires and terminations each year. Any Ideas?

Re: Hires & Terminations

giakoum — Fri, 17 Apr 2015 16:41:56 GMT

create two year fields based on Employment Date and Termination Date and then use count( distinct EMPNO) as expression with the newly created years as dimension (2 different charts)

Re: Hires & Terminations

jpenuliar — Fri, 17 Apr 2015 17:48:01 GMT

You can take inspiration from the demo file "Human Resources.qvw" from Qlik website.

Re: Hires & Terminations

Anonymous — Fri, 17 Apr 2015 18:52:25 GMT

If you want to show both the counts on the same chart (i.e. bar chart), create a date island table (year,qtr etc) then

use the year field from this table and add 2 expressions like this,

count( DISTINCT if(year=hire_year,emp_cnt)

count( DISTINCT if(year=year_terminated,emp_cnt)

Re: Hires & Terminations

ramoncova06 — Fri, 17 Apr 2015 19:23:32 GMT

you could use a canonical calendar

Canonical Date

Re: Hires & Terminations

Fri, 17 Apr 2015 20:29:02 GMT

How should I create the two year fields?

Re: Hires & Terminations

ramoncova06 — Fri, 17 Apr 2015 20:34:54 GMT

creating a master calendar should be a good way to start

The Master Calendar

Re: Hires & Terminations

Sat, 18 Apr 2015 09:37:48 GMT

Can I do it without creating the master table? How can i extract just the year from the employment date and compare it with the payroll year?