topic Re: Working out the average time for a specific code in QlikView https://community.qlik.com/t5/QlikView/Working-out-the-average-time-for-a-specific-code/m-p/385038#M1165843 <HTML><HEAD></HEAD><BODY><P>Awesome - thanks a lot. Qlikview is pretty amazing.</P></BODY></HTML> Thu, 06 Sep 2012 14:53:00 GMT 2012-09-06T14:53:00Z Working out the average time for a specific code https://community.qlik.com/t5/QlikView/Working-out-the-average-time-for-a-specific-code/m-p/385036#M1165841 <HTML><HEAD></HEAD><BODY><P>I have a table that looks like this:</P><P><IMG __jive_id="21447" class="jive-image" alt="pic.png" src="https://community.qlik.com/legacyfs/online/21447_pic.png" /></P><P>What I want to do is add another column that shows the average number of minutes spent for all calls for the problem code that the call is linked to. Can anyone suggest how I would go about working it out? I'm not sure how I would write an expression to capture the sum of minutes spent for the specific problem code.</P></BODY></HTML> Thu, 06 Sep 2012 14:47:17 GMT https://community.qlik.com/t5/QlikView/Working-out-the-average-time-for-a-specific-code/m-p/385036#M1165841 2012-09-06T14:47:17Z Re: Working out the average time for a specific code https://community.qlik.com/t5/QlikView/Working-out-the-average-time-for-a-specific-code/m-p/385037#M1165842 <HTML><HEAD></HEAD><BODY><P>Add an expression:</P><P></P><P>Avg(TOTAL &lt;[Problem Code]&gt; [Minutes Spent])</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Thu, 06 Sep 2012 14:50:25 GMT https://community.qlik.com/t5/QlikView/Working-out-the-average-time-for-a-specific-code/m-p/385037#M1165842 Jason_Michaelides 2012-09-06T14:50:25Z Re: Working out the average time for a specific code https://community.qlik.com/t5/QlikView/Working-out-the-average-time-for-a-specific-code/m-p/385038#M1165843 <HTML><HEAD></HEAD><BODY><P>Awesome - thanks a lot. Qlikview is pretty amazing.</P></BODY></HTML> Thu, 06 Sep 2012 14:53:00 GMT https://community.qlik.com/t5/QlikView/Working-out-the-average-time-for-a-specific-code/m-p/385038#M1165843 2012-09-06T14:53:00Z Re: Working out the average time for a specific code https://community.qlik.com/t5/QlikView/Working-out-the-average-time-for-a-specific-code/m-p/385039#M1165844 <HTML><HEAD></HEAD><BODY><P>That it is <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 06 Sep 2012 14:53:34 GMT https://community.qlik.com/t5/QlikView/Working-out-the-average-time-for-a-specific-code/m-p/385039#M1165844 Jason_Michaelides 2012-09-06T14:53:34Z