topic Average in QlikView https://community.qlik.com/t5/QlikView/Average/m-p/983644#M973016 <HTML><HEAD></HEAD><BODY><P>I have a table with start time and end time lik this </P><P>EmplID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; StartTime&nbsp;&nbsp; EndTime</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:00:00</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11:00:00</P><P></P><P>I want to calcluate average time spent</P></BODY></HTML> Mon, 07 Sep 2015 06:24:03 GMT gautik92 2015-09-07T06:24:03Z Average https://community.qlik.com/t5/QlikView/Average/m-p/983644#M973016 <HTML><HEAD></HEAD><BODY><P>I have a table with start time and end time lik this </P><P>EmplID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; StartTime&nbsp;&nbsp; EndTime</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:00:00</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11:00:00</P><P></P><P>I want to calcluate average time spent</P></BODY></HTML> Mon, 07 Sep 2015 06:24:03 GMT https://community.qlik.com/t5/QlikView/Average/m-p/983644#M973016 gautik92 2015-09-07T06:24:03Z Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/983645#M973017 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>sum((StartTime-EndTime)/<SPAN style="font-size: 13.3333px;">(StartTime+EndTime))</SPAN></P></BODY></HTML> Mon, 07 Sep 2015 06:27:13 GMT https://community.qlik.com/t5/QlikView/Average/m-p/983645#M973017 2015-09-07T06:27:13Z Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/983646#M973018 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can also use the avg function</P></BODY></HTML> Mon, 07 Sep 2015 06:27:39 GMT https://community.qlik.com/t5/QlikView/Average/m-p/983646#M973018 2015-09-07T06:27:39Z Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/983647#M973019 <HTML><HEAD></HEAD><BODY><P>Assuming that the start time and end time are proper QV time values, then</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Interval(Avg(EndTime - StartTime))</P><P></P><P>If they are string values</P><P></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Interval(Avg(Time#(EndTime, 'hh:mm:ss') - Time#(StartTime, 'hh:mm:ss')))</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Interval can also take a format parameter, so you can format the result (for example as hours&nbsp; Interval(..., 'h')<BR /></SPAN></P></BODY></HTML> Mon, 07 Sep 2015 06:28:44 GMT https://community.qlik.com/t5/QlikView/Average/m-p/983647#M973019 jonathandienst 2015-09-07T06:28:44Z Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/983648#M973020 <HTML><HEAD></HEAD><BODY><P>it dint work</P></BODY></HTML> Mon, 07 Sep 2015 06:29:08 GMT https://community.qlik.com/t5/QlikView/Average/m-p/983648#M973020 gautik92 2015-09-07T06:29:08Z