topic Needing average of expression total in QlikView https://community.qlik.com/t5/QlikView/Needing-average-of-expression-total/m-p/652984#M1079639 <HTML><HEAD></HEAD><BODY><P>I an new to Qlikview and I currently have an expression that is derived by the following:</P><P></P><P>Variance Amt] / [Ext Price Paid]</P><P></P><P>where Variance Amt&nbsp; and Ext Price Paid are also expressions.&nbsp; I had in the Total Mode, sum of all rows selected, but what I really need is the average savings of the rows selected and not the total.&nbsp;&nbsp;&nbsp; See the two screen shots.</P><P></P><P>Any help is greatly appreciated!</P></BODY></HTML> Thu, 10 Jul 2014 14:50:51 GMT triciagdaly 2014-07-10T14:50:51Z Needing average of expression total https://community.qlik.com/t5/QlikView/Needing-average-of-expression-total/m-p/652984#M1079639 <HTML><HEAD></HEAD><BODY><P>I an new to Qlikview and I currently have an expression that is derived by the following:</P><P></P><P>Variance Amt] / [Ext Price Paid]</P><P></P><P>where Variance Amt&nbsp; and Ext Price Paid are also expressions.&nbsp; I had in the Total Mode, sum of all rows selected, but what I really need is the average savings of the rows selected and not the total.&nbsp;&nbsp;&nbsp; See the two screen shots.</P><P></P><P>Any help is greatly appreciated!</P></BODY></HTML> Thu, 10 Jul 2014 14:50:51 GMT https://community.qlik.com/t5/QlikView/Needing-average-of-expression-total/m-p/652984#M1079639 triciagdaly 2014-07-10T14:50:51Z Re: Needing average of expression total https://community.qlik.com/t5/QlikView/Needing-average-of-expression-total/m-p/652985#M1079640 <HTML><HEAD></HEAD><BODY><P>Did you try to change the Total Mode to "Average"?</P><P></P><P><IMG alt="avg.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/62196_avg.png" /></P></BODY></HTML> Thu, 10 Jul 2014 14:55:07 GMT https://community.qlik.com/t5/QlikView/Needing-average-of-expression-total/m-p/652985#M1079640 2014-07-10T14:55:07Z Re: Needing average of expression total https://community.qlik.com/t5/QlikView/Needing-average-of-expression-total/m-p/652986#M1079641 <HTML><HEAD></HEAD><BODY><P>Thank you..&nbsp; I didn't even notice the drop down. </P><P></P><P>Obviously a good training course would be ideal!!!</P></BODY></HTML> Thu, 10 Jul 2014 15:00:15 GMT https://community.qlik.com/t5/QlikView/Needing-average-of-expression-total/m-p/652986#M1079641 triciagdaly 2014-07-10T15:00:15Z Re: Needing average of expression total https://community.qlik.com/t5/QlikView/Needing-average-of-expression-total/m-p/652987#M1079642 <HTML><HEAD></HEAD><BODY><P>Training would be nice, but you also have this great community of thousands of people <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 10 Jul 2014 15:03:14 GMT https://community.qlik.com/t5/QlikView/Needing-average-of-expression-total/m-p/652987#M1079642 2014-07-10T15:03:14Z