How to find working days?

gaurav2017 — Tue, 03 Oct 2017 11:27:03 GMT

Hi Friends,

I have 3 tables:

1. EmpPresent Table contains below fields:

a. EmpID

b. Date of Hire

2. EmpVacationDetails Table contains below fields:

a. EmpID

b. VacationStartDate

c. VacationEndDate

d. VacationDays

3. PublicHolidays Table contains below fields:

a. HDay

b. HMonth

c. Description

Problem:

I want the data in the below format and in 1 table. I am also fine if the output data is even date wise.:

Output:

a. EmpID

b. Month

c. Year

d. Number of WeekDays

e. Number of WeekEnds

f. Number of Public Holidays

g. Number of Vacations

h. Number of Working Days

Calculation for

Number of Working Days = (Number of WeekDays) - (Number of Public Holidays + Number of Vacations)

What should be the best approach?

Feel free if you need sample data for the same or any inputs. Thanks in advance.

Re: How to find working days?

sunny_talwar — Tue, 03 Oct 2017 11:34:56 GMT

Have you already looked at networkdays ‒ QlikView

its_anandrjs — Tue, 03 Oct 2017 12:13:36 GMT

Best is you can Flag this type of the dates in the data model and then do calculation for this is the best approach to you.