topic Schedule Matrix in QlikView

Schedule Matrix

quiquehm — Mon, 20 Mar 2017 22:08:03 GMT

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 :

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

I would appreciate any guidance you could give me here.

Many thanks in advance

Enrique

Re: Schedule Matrix

ahaahaaha — Tue, 21 Mar 2017 09:04:20 GMT

Hi Enrique,

View this links

Master Calendar with movable holidays

How to remove weekend and holidays from your calculation‌

Regards,

Andrey

Re: Schedule Matrix

quiquehm — Tue, 21 Mar 2017 17:55:03 GMT

Thanks Andrey for providing these links, there are tons of good information there.

I already read a god post by legend Henric Cronström, where I learnt how to create all reference dates for my dates intervals ( date_start and date_finish )

Creating Reference Dates for Intervals

I wondered if there would be a simple script modification to that one already in my app, that could provide all the reference dates between my start and finish dates BUT excluding the weekends ( and optionally holidays ).

I could probably join that table to a master calendar to get my expected result ( as in my excel mockup printscreen )

FillDates:

LOAD

key,

networkdays(date_start, date_finish) as Work_days,

Date(date_start + IterNo()-1) as date_Fill

RESIDENT Tasks

While IterNo()<= date_finish - date_start + 1;

Thanks again for your time and help