3 Replies Latest reply: Sep 25, 2012 9:06 PM by Niels van Diermen RSS

    Sum Value outside of selection

      Hi There,

       

      For some reason I can't do this in QlikView...

       

      What I'm trying to do is this...

       

      I have a calendar table:

       

      Key_Date, WorkingHoursInDay

      01/01/2012, 8

      02/01/2012, 0

      03/01/2012, 8

      04/01/2012, 8

      05/01/2012, 8

       

       

      JobID, JobStart, JobEnd

      7, 01/01/2012, 01/03/2012

      8, 04/01/2012, 05/01/2012

       

      I would like a chart that has:

       

      Job Number, JobStart, JobEnd And then Sum(WorkingHoursInDay) Between JobStart And JobEnd

       

      e.g.

      7, 01/01/2012, 01/03/2012, 16 Hours

      8, 01/01/2012, 05/01/2012, 32 Hours

       

      Any ideas on how to do this?

       

      Thanks