topic Re: Avg Time in QlikView https://community.qlik.com/t5/QlikView/Avg-Time/m-p/1268939#M399376 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Interval(Time#(Floor(Avg(Aggr(Sum(Seconds)/Count(Topic)/60, Topic, ID, Seconds))), 'mm'), 'D hh:mm')</STRONG></P></BODY></HTML> Thu, 15 Dec 2016 14:55:53 GMT sunny_talwar 2016-12-15T14:55:53Z Avg Time https://community.qlik.com/t5/QlikView/Avg-Time/m-p/1268938#M399375 <HTML><HEAD></HEAD><BODY><P>Hello fellow Qlikicians</P><P></P><P>Looking for an aggr expression within a Text Box to convert seconds into an Avg time in 'D hh:mm' format.&nbsp; Aggr by Topic.&nbsp; I've attached a qvw.&nbsp; The answer should be 0 00:24 </P><P></P><P>Thank you!</P></BODY></HTML> Thu, 15 Dec 2016 14:04:29 GMT https://community.qlik.com/t5/QlikView/Avg-Time/m-p/1268938#M399375 2016-12-15T14:04:29Z Re: Avg Time https://community.qlik.com/t5/QlikView/Avg-Time/m-p/1268939#M399376 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Interval(Time#(Floor(Avg(Aggr(Sum(Seconds)/Count(Topic)/60, Topic, ID, Seconds))), 'mm'), 'D hh:mm')</STRONG></P></BODY></HTML> Thu, 15 Dec 2016 14:55:53 GMT https://community.qlik.com/t5/QlikView/Avg-Time/m-p/1268939#M399376 sunny_talwar 2016-12-15T14:55:53Z Re: Avg Time https://community.qlik.com/t5/QlikView/Avg-Time/m-p/1268940#M399377 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Yes.&nbsp; Thank you so much!</P></BODY></HTML> Thu, 15 Dec 2016 15:16:47 GMT https://community.qlik.com/t5/QlikView/Avg-Time/m-p/1268940#M399377 2016-12-15T15:16:47Z