Calculating FTE (numbet of employees) and Avaialable hours of work

[AnnaKinch]

Hi!

I amusing Qlik Sense Desktop. I have a column for reported hours of work for each employee, and a column with date. I want to caclulate the number of FTEs (Full Time Employees) by dividing the reported hours with the available hours of work. SoI would like to be able to filter by month or year and see the numer of FTE for that period.

Thanks,

[nisha_rai]

Hi,

Can you share the sample data and expected result.

[AnnaKinch]

Hi!

I enclose the data, one sheet with worked hours and one sheet with available hours. The data is from the whole  of 2013 and part  of 2014.

I'm not sure about expected result.

I would like to be able to choose per year and month.

Thanks for taking interest 🙂