Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Need to create average hours per employee per month

Hi - I would like to create a chart with the average overtime per employee by month by work department.  The table which has employee and total hours is joined to the calendar table by the work week ending field.  I need the calendar table to group by month/year.  How can I aggregate the employees by month to give an average?  In excel I am doing Total Hours/Distinct Employee.  Please let me know if you need more info to answer this question.  This is the first time I've submitted anything to this community.

1 Reply
MVP & Luminary
MVP & Luminary

Re: Need to create average hours per employee per month


Can you attach some sample file?