topic Re: Group durations across multiple weeks By Week in QlikView

Group durations across multiple weeks By Week

Fri, 29 Apr 2016 15:31:42 GMT

Hi all,

I have a table which contains the downtime of machines. It looks something similar to the below table:

Therefore I have the following situation:

I am trying to find a way such that I can the downtime i.e Duration (Days) by weeks, as following:

Can someone please recommend how this can be achieved?

Thanks!

Re: Group durations across multiple weeks By Week

sunny_talwar — Fri, 29 Apr 2016 15:59:18 GMT

Would you be able to explain the logic of downtime Duration? I can't seem to find a relations between your input table and the Gantt chart witht he expected output table.

Re: Group durations across multiple weeks By Week

sunny_talwar — Sat, 30 Apr 2016 01:42:57 GMT

I think I get it now

Script:

SET FirstWeekDay=0;

Table:

LOAD * Inline [

Duration ID, Start Day, End Day, Duration

D001, 16/04/2016, 22/04/2016, 7

D002, 11/04/2016, 29/04/2016, 19

D003, 16/04/2016, 24/04/2016, 9

];

Table:

LOAD [Duration ID],

Duration,

[Start Day],

[End Day],

Date([Start Day] + IterNo() - 1) as Date,

Week([Start Day] + IterNo() - 1) as Week,

WeekDay([Start Day] + IterNo() - 1) as WeekDay

Resident Table

While [Start Day] + IterNo() - 1 <= [End Day];

DROP Table Table;

I don't know how you are calculating your Week, but the the idea will remain the same the Week calculation will change.

Best,

Sunny

Re: Group durations across multiple weeks By Week

Tue, 03 May 2016 10:46:53 GMT

Hi Sunny,

Sorry for the late replay.

I just applied your example in my application and it worked perfectly!

Thanks again for your contribution!