2 Replies Latest reply: Mar 21, 2017 1:55 PM by Enrique Herranz RSS

    Schedule Matrix

    Enrique Herranz

      Hi Experts !

      I wondered if you could give me some help on a small app I am trying to create to build a very simple schedule table. I have a list of tasks with a start and finish dates fields. I manage to create all the dates in between those start and finish dates, so I can represent these easily , as can be seen in attached qvw file. The problem is I would need to skip all weekends ( and optionally holiday dates ), so the duration of these tasks should account for only working days. I am not sure how I would need to enter the holiday dates , maybe an INLINE table ...but how ? . Also I would need to see days in between two tasks even if there is no work done on these dates.

      Current qvw app chart :

      Schedule_qvw.PNG

      Expected chart ( what I would need ) , based on an excel mockup :

      Schedule_expected.PNG

      I would appreciate any guidance you could give me here.

      Many thanks in advance

      Enrique