topic Weekly Average of summed fields help in QlikView https://community.qlik.com/t5/QlikView/Weekly-Average-of-summed-fields-help/m-p/248439#M582456 <HTML><HEAD></HEAD><BODY><P>talleyrobyn,</P><P></P><P>maybe it's just a typo in this forum post, but I would have expected to see brackets enclosing the 6 sums, then the sum of sums divided by the count of distinct Thursdays.</P><P></P><P>If it is just a typo, I don't have a real idea of what is going on, maybe some sample data might help here.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Tue, 22 Nov 2011 22:51:05 GMT swuehl 2011-11-22T22:51:05Z Weekly Average of summed fields help https://community.qlik.com/t5/QlikView/Weekly-Average-of-summed-fields-help/m-p/248438#M582455 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Below I am trying to sum 6 different fields and then get a weekly average for the time frame I have filtered for.&nbsp; I need help because my result is just the sum of the 6 fields.&nbsp; The Thursday field in my dashboard is the same as Week Ending.&nbsp; What I am scripting wrong in my expression?&nbsp; This expression is used in a straight table.&nbsp; Any help would be greatly appreciated!</SPAN></P><P><SPAN style="color: #000000;"> </SPAN></P><P><SPAN style="color: #000000;">Thanks!</SPAN></P><P><SPAN style="color: #000000;"> </SPAN></P><P><SPAN style="color: #0000ff;"></SPAN></P><P>sum</P><P></P><P>(<SPAN style="color: #800000;">[Discount_Card/ReferralCount]</SPAN>)+<SPAN style="color: #0000ff;">Sum</SPAN>(<SPAN style="color: #800000;">[Group_ADD/ReferralCount]</SPAN>)+<SPAN style="color: #0000ff;">Sum</SPAN>(<SPAN style="color: #800000;">[Child_Safe/ReferralCount]</SPAN>)+<SPAN style="color: #0000ff;">Sum</SPAN>(<SPAN style="color: #800000;">[Child_Safe_Kit/ReferralCount]</SPAN>)+ <SPAN style="color: #0000ff;">Sum</SPAN>(<SPAN style="color: #800000;">[Individual_ADD/ReferralCount]</SPAN>)+ <SPAN style="color: #0000ff;">Sum</SPAN>(<SPAN style="color: #800000;">[Internet_Surfin_Guide/ReferralCount]</SPAN>)/(<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #0000ff;">distinct</SPAN> <SPAN style="color: #800000;">Thursday</SPAN>))</P></BODY></HTML> Tue, 22 Nov 2011 20:11:55 GMT https://community.qlik.com/t5/QlikView/Weekly-Average-of-summed-fields-help/m-p/248438#M582455 2011-11-22T20:11:55Z Weekly Average of summed fields help https://community.qlik.com/t5/QlikView/Weekly-Average-of-summed-fields-help/m-p/248439#M582456 <HTML><HEAD></HEAD><BODY><P>talleyrobyn,</P><P></P><P>maybe it's just a typo in this forum post, but I would have expected to see brackets enclosing the 6 sums, then the sum of sums divided by the count of distinct Thursdays.</P><P></P><P>If it is just a typo, I don't have a real idea of what is going on, maybe some sample data might help here.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Tue, 22 Nov 2011 22:51:05 GMT https://community.qlik.com/t5/QlikView/Weekly-Average-of-summed-fields-help/m-p/248439#M582456 swuehl 2011-11-22T22:51:05Z