topic Re: Average calculation in QlikView https://community.qlik.com/t5/QlikView/Average-calculation/m-p/1221422#M865371 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Sum(Aggr(Count(DISTINCT{$&lt;AUD_ResultCode={'*Remote*'}&gt;}AUD_ResultCode), name))/24/Sum(Aggr(Max(ActionTime)-Min(ActionTime), name))</STRONG></P></BODY></HTML> Thu, 22 Dec 2016 03:29:32 GMT sunny_talwar 2016-12-22T03:29:32Z Average calculation https://community.qlik.com/t5/QlikView/Average-calculation/m-p/1221421#M865370 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please see attached.</P><P></P><P>I am trying to get the the number of orders completed / interval time i.e. the&nbsp; result of 12 /16:32:12 either in a text box or as a total in the column 'Orders Completed per hour". The result should be 0.73. Tried a couple of things, but it does not seem to work.</P><P></P><P>Any ideas?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Average-calculation/m-p/1221421#M865370 shamitshah 2020-11-25T16:16:04Z Re: Average calculation https://community.qlik.com/t5/QlikView/Average-calculation/m-p/1221422#M865371 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Sum(Aggr(Count(DISTINCT{$&lt;AUD_ResultCode={'*Remote*'}&gt;}AUD_ResultCode), name))/24/Sum(Aggr(Max(ActionTime)-Min(ActionTime), name))</STRONG></P></BODY></HTML> Thu, 22 Dec 2016 03:29:32 GMT https://community.qlik.com/t5/QlikView/Average-calculation/m-p/1221422#M865371 sunny_talwar 2016-12-22T03:29:32Z Re: Average calculation https://community.qlik.com/t5/QlikView/Average-calculation/m-p/1221423#M865372 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>Thanks! Works just fine.</P></BODY></HTML> Thu, 22 Dec 2016 03:46:23 GMT https://community.qlik.com/t5/QlikView/Average-calculation/m-p/1221423#M865372 shamitshah 2016-12-22T03:46:23Z