topic Calculating the time duration between records excluding non working hours & days in QlikView https://community.qlik.com/t5/QlikView/Calculating-the-time-duration-between-records-excluding-non/m-p/702896#M253606 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The scenario I have is workflow where applications pass through different stages, Each stage generates a new record in the dataset for that application. I want to calculate the time taken to progress between each stage. This I can calculate by subtracting the timestamp of the current record from the previous record, however my challenge is that I need to be able to factor out weekends, and non working hours and public holidays. During some parts of the year, the working days are only 6 hours compared to the usual 8 hours, so I need to be able to set the number of working hours on any given day in the year.</P><P></P><P>Lets Assume that the working week is 6 days Sunday to Thursday and the working hours are 8AM - 5PM. An application created at 4PM on Thursday and progressing to the next step on Sunday at 10AM should calculate a duration of 3 hours.</P><P></P><P>is this achievable?</P><P></P><P>Attached is some data and an app.</P><P></P><P>Any help greatly appreciated!</P><P></P><P>Thanks</P></BODY></HTML> Fri, 18 Jul 2014 08:47:05 GMT 2014-07-18T08:47:05Z Calculating the time duration between records excluding non working hours & days https://community.qlik.com/t5/QlikView/Calculating-the-time-duration-between-records-excluding-non/m-p/702896#M253606 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The scenario I have is workflow where applications pass through different stages, Each stage generates a new record in the dataset for that application. I want to calculate the time taken to progress between each stage. This I can calculate by subtracting the timestamp of the current record from the previous record, however my challenge is that I need to be able to factor out weekends, and non working hours and public holidays. During some parts of the year, the working days are only 6 hours compared to the usual 8 hours, so I need to be able to set the number of working hours on any given day in the year.</P><P></P><P>Lets Assume that the working week is 6 days Sunday to Thursday and the working hours are 8AM - 5PM. An application created at 4PM on Thursday and progressing to the next step on Sunday at 10AM should calculate a duration of 3 hours.</P><P></P><P>is this achievable?</P><P></P><P>Attached is some data and an app.</P><P></P><P>Any help greatly appreciated!</P><P></P><P>Thanks</P></BODY></HTML> Fri, 18 Jul 2014 08:47:05 GMT https://community.qlik.com/t5/QlikView/Calculating-the-time-duration-between-records-excluding-non/m-p/702896#M253606 2014-07-18T08:47:05Z