Employees active in a given date

Anonymous — Wed, 24 Jan 2018 19:58:24 GMT

Hello everyone!

In my model I have a table called Employee with different employee data. In that table I've got the field START_DATE and END_DATE of the period worked by the employee. As for now I have two calendars, one linked with the Employee table by START_DATE and another one linked with the Employee table by END_DATE.

I would need to have some entity that allow me to see for each month how many employees are active.

For example:

If the date 10/06/2016 is selected the three employees should be active, if the date 25/06/2016 is selected 2 employees are active (Emp1 and Emp3). Emp3 should be active for dates selected from 23/02/2014.

¿How can I do this?

Thank you so much!

Re: Employees active in a given date

MarcoWedel — Wed, 24 Jan 2018 22:19:33 GMT

one solution could be:

Creating Reference Dates for Intervals

hope this helps

regards

Marco

Re: Employees active in a given date

Anonymous — Thu, 25 Jan 2018 17:35:28 GMT

Thank you! This is exactly what I was looking for!

topic Re: Employees active in a given date in QlikView

Employees active in a given date

Re: Employees active in a given date

Re: Employees active in a given date