Work Week Query - Qlik Community

Dayna · ‎2011-03-02

Hello All,

I have been set a challenge to show whether an incident has been resolved within one working day, i.e. If an Incident is raised at 4pm on Friday they have till 4pm on Monday to resolve the issue.. And likewise, if an Incident is raised at 19:00 it wouldn't count till 09:00 the next morning. (Work week is Mon-Fri 0900:-17:00)

I was thinking of using flags in the load script, i.e. OpenDate +24 < ClosedDate... But no idea!

Please help!!

Many thanks in advance,
Dayna

deepakk · ‎2011-03-02

hi Dayna,

The second incident is not clear. if the call is logged at 19:00 of ? then till what time its consider as one day.

gandalfgray · ‎2011-03-02


Deepak Kurup wrote:
The second incident is not clear. if the call is logged at 19:00 of ? then till what time its consider as one day.
 <div></div>

That must be until 17:00 the next working day.

Dayna · ‎2011-03-02

Exactly, so our week work in Monday-Friday 0900 - 1700. If someone raised a call at 1900 on a friday evening then the clock wouldn't start ticking till 0900 Monday (As this is the first instance of a working day). Then you would have one working day to resolve this (which would be 1700 on the same day).

If a call came it at 1500 on Monday then you would have till 1459 on Tuesday.. etc etc.

Many thanks for your help.
Dayna