topic Re: calculating an average in QlikView https://community.qlik.com/t5/QlikView/calculating-an-average/m-p/587573#M1114590 <HTML><HEAD></HEAD><BODY><P>Hi Henric</P><P></P><P>Your suggested solution works perfectly.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 17 Feb 2014 10:08:54 GMT 2014-02-17T10:08:54Z calculating an average https://community.qlik.com/t5/QlikView/calculating-an-average/m-p/587571#M1114588 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to calculate the average processing time based on the difference between datetimeprocessed and datetimereceived.. But I only want to calculate the average for rows where there is a value in datetimeprocessed field.</P><P></P><P>I am trying to use the following expression to achieve this:</P><P></P><P>=sum(Interval(DateTimeProcessed-DateTimeReceived))/$Rows</P><P></P><P>I am not sure if the above is correct. Can someone please help me with getting the correct expression.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 14 Feb 2014 13:00:07 GMT https://community.qlik.com/t5/QlikView/calculating-an-average/m-p/587571#M1114588 2014-02-14T13:00:07Z Re: calculating an average https://community.qlik.com/t5/QlikView/calculating-an-average/m-p/587572#M1114589 <HTML><HEAD></HEAD><BODY><P>Avg(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateTimeProcessed-DateTimeReceived</SPAN>) should work. Or you can use</P><P>Sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateTimeProcessed-DateTimeReceived</SPAN>)/Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateTimeProcessed-DateTimeReceived</SPAN>) </P><P></P><P>In both cases, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateTimeProcessed-DateTimeReceived is evaluated to NULL when one of the fields is missing, and will then not be included.</SPAN></P><P></P><P>HIC</P></BODY></HTML> Fri, 14 Feb 2014 13:58:46 GMT https://community.qlik.com/t5/QlikView/calculating-an-average/m-p/587572#M1114589 hic 2014-02-14T13:58:46Z Re: calculating an average https://community.qlik.com/t5/QlikView/calculating-an-average/m-p/587573#M1114590 <HTML><HEAD></HEAD><BODY><P>Hi Henric</P><P></P><P>Your suggested solution works perfectly.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 17 Feb 2014 10:08:54 GMT https://community.qlik.com/t5/QlikView/calculating-an-average/m-p/587573#M1114590 2014-02-17T10:08:54Z