5 Replies Latest reply: Feb 27, 2014 3:51 PM by whiteline _ RSS

    Average hours per workday

      Hi all,

       

      I'm relatively new to QlikView and was wondering if there is a method to aggregate all workdays to an average working hours, and then show them in a Gantt-chart style.

      I've searched the community already and couldn't find the answer, probably because I can't formulate my question adequately.

      I already got the following: It shows all dates in day names date(<datefield goes here> 'WWWW') over an period of some weeks.

       

      Capture.PNG.png

       

      The expression is a simple SUM of total work time (end-start time) with an offset on the start time.

      But what i want is the following (I made a selection of last week data)

      Capture.PNG.png

       

      The data is in Dutch and represents the weekdays monday-friday.

       

      I sure hope it's possible!

       

      Kind regards,

      Job van den Berg