topic Interval between timestamp with no holiday in QlikView https://community.qlik.com/t5/QlikView/Interval-between-timestamp-with-no-holiday/m-p/998021#M649175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have log_from and Log_to and I have done an timestamp interval, my problem is the NetWorksdays is one day I want to excluding the time for I have in holiday in my calculation.</P><P></P><P>Log_From&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log_to&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Interval&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I want to have</P><P>2009-08-21 10:54:16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2009-08-26 13:42:43&nbsp;&nbsp;&nbsp;&nbsp; 05 - 02:48:27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 - 02:48:27</P><P></P><P>It log_from is on a Saturday I want to excluding only the time not the all day.</P><P></P><P>Cheers Viktoria</P></BODY></HTML> Tue, 22 Sep 2015 08:40:14 GMT 2015-09-22T08:40:14Z Interval between timestamp with no holiday https://community.qlik.com/t5/QlikView/Interval-between-timestamp-with-no-holiday/m-p/998021#M649175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have log_from and Log_to and I have done an timestamp interval, my problem is the NetWorksdays is one day I want to excluding the time for I have in holiday in my calculation.</P><P></P><P>Log_From&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log_to&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Interval&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I want to have</P><P>2009-08-21 10:54:16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2009-08-26 13:42:43&nbsp;&nbsp;&nbsp;&nbsp; 05 - 02:48:27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 - 02:48:27</P><P></P><P>It log_from is on a Saturday I want to excluding only the time not the all day.</P><P></P><P>Cheers Viktoria</P></BODY></HTML> Tue, 22 Sep 2015 08:40:14 GMT https://community.qlik.com/t5/QlikView/Interval-between-timestamp-with-no-holiday/m-p/998021#M649175 2015-09-22T08:40:14Z