topic How To Display Monthly Average... in QlikView https://community.qlik.com/t5/QlikView/How-To-Display-Monthly-Average/m-p/162280#M35841 <HTML><HEAD></HEAD><BODY><P>Thank you for quick reply... I will check on this hope this is the one I'm looking for...</P></BODY></HTML> Tue, 25 May 2010 04:49:41 GMT 2010-05-25T04:49:41Z How To Display Monthly Average... https://community.qlik.com/t5/QlikView/How-To-Display-Monthly-Average/m-p/162278#M35839 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Hope you can help me attain my DESIRED OUTPUT:</P><P>Given tables are:</P><P>CUSTOMER TARGET TABLE<BR />SALES TRANSACTIONS</P><P>SALES TABLE below are just a summary of daily transaction grouped monthly.<BR />What i need to be displayed is Monthly Average based on this group.</P><P>Please see illustration below:</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1683_sourceID:1683" /></P><P></P><P>Hope you can help on this matter.</P><P>Thanks in advance</P><P>Marson</P></BODY></HTML> Mon, 24 May 2010 10:50:47 GMT https://community.qlik.com/t5/QlikView/How-To-Display-Monthly-Average/m-p/162278#M35839 2010-05-24T10:50:47Z How To Display Monthly Average... https://community.qlik.com/t5/QlikView/How-To-Display-Monthly-Average/m-p/162279#M35840 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Expression would be like below.</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Sum(Sales) / Count(Distinct Month)<BR />Untested Expression.<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>-Peterson</P></BODY></HTML> Mon, 24 May 2010 11:30:23 GMT https://community.qlik.com/t5/QlikView/How-To-Display-Monthly-Average/m-p/162279#M35840 2010-05-24T11:30:23Z How To Display Monthly Average... https://community.qlik.com/t5/QlikView/How-To-Display-Monthly-Average/m-p/162280#M35841 <HTML><HEAD></HEAD><BODY><P>Thank you for quick reply... I will check on this hope this is the one I'm looking for...</P></BODY></HTML> Tue, 25 May 2010 04:49:41 GMT https://community.qlik.com/t5/QlikView/How-To-Display-Monthly-Average/m-p/162280#M35841 2010-05-25T04:49:41Z