topic expression for YTD Average in QlikView https://community.qlik.com/t5/QlikView/expression-for-YTD-Average/m-p/634274#M476896 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can someone tell me what is wrong with this expression:</P><P></P><P>=(<SPAN style="color: #0000ff;">Sum</SPAN>({$&lt;<SPAN style="color: #800000;">ActivityKey</SPAN> ={10},<SPAN style="color: #800000;">serviceprovider</SPAN>={H}&gt;}<SPAN style="color: #800000;">ActualValue</SPAN>)/<SPAN style="color: #0000ff;">Count</SPAN>({$&lt;<SPAN style="color: #800000;">ActivityKey</SPAN> ={10},<SPAN style="color: #800000;">serviceprovider</SPAN>={H}&gt;}<SPAN style="color: #800000;">ActualValue</SPAN>))/<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">ReferredMM</SPAN>) </P><P></P><P></P><P>I have a straight table with expressions for each month which shows an average per month.&nbsp; Then this above is to show the total of these months or the overall figure which is an average divided by the number of months to get a YTD average.</P><P></P><P>Thanks</P><P></P><P>Rhona</P></BODY></HTML> Thu, 15 May 2014 08:59:26 GMT rcorcoran 2014-05-15T08:59:26Z expression for YTD Average https://community.qlik.com/t5/QlikView/expression-for-YTD-Average/m-p/634274#M476896 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can someone tell me what is wrong with this expression:</P><P></P><P>=(<SPAN style="color: #0000ff;">Sum</SPAN>({$&lt;<SPAN style="color: #800000;">ActivityKey</SPAN> ={10},<SPAN style="color: #800000;">serviceprovider</SPAN>={H}&gt;}<SPAN style="color: #800000;">ActualValue</SPAN>)/<SPAN style="color: #0000ff;">Count</SPAN>({$&lt;<SPAN style="color: #800000;">ActivityKey</SPAN> ={10},<SPAN style="color: #800000;">serviceprovider</SPAN>={H}&gt;}<SPAN style="color: #800000;">ActualValue</SPAN>))/<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">ReferredMM</SPAN>) </P><P></P><P></P><P>I have a straight table with expressions for each month which shows an average per month.&nbsp; Then this above is to show the total of these months or the overall figure which is an average divided by the number of months to get a YTD average.</P><P></P><P>Thanks</P><P></P><P>Rhona</P></BODY></HTML> Thu, 15 May 2014 08:59:26 GMT https://community.qlik.com/t5/QlikView/expression-for-YTD-Average/m-p/634274#M476896 rcorcoran 2014-05-15T08:59:26Z Re: expression for YTD Average https://community.qlik.com/t5/QlikView/expression-for-YTD-Average/m-p/634275#M476897 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> without the document.. Maybe it is due to a missing distinct in the count?</P></BODY></HTML> Thu, 15 May 2014 09:01:32 GMT https://community.qlik.com/t5/QlikView/expression-for-YTD-Average/m-p/634275#M476897 bbi_mba_76 2014-05-15T09:01:32Z