topic count for a certain selected year/month in QlikView https://community.qlik.com/t5/QlikView/count-for-a-certain-selected-year-month/m-p/683473#M1078919 <HTML><HEAD></HEAD><BODY><P>I'm having trouble writing a set analysis.</P><P></P><P>I want to calculate the avg(sum(weight)) for this year or for a selected month.</P><P></P><P>The month is also a calculated field: month(empty_date)</P><P>Because emprt_date is a timestamp.</P><P></P><P>Can anyone help me write this?</P></BODY></HTML> Wed, 16 Jul 2014 07:32:14 GMT 2014-07-16T07:32:14Z count for a certain selected year/month https://community.qlik.com/t5/QlikView/count-for-a-certain-selected-year-month/m-p/683473#M1078919 <HTML><HEAD></HEAD><BODY><P>I'm having trouble writing a set analysis.</P><P></P><P>I want to calculate the avg(sum(weight)) for this year or for a selected month.</P><P></P><P>The month is also a calculated field: month(empty_date)</P><P>Because emprt_date is a timestamp.</P><P></P><P>Can anyone help me write this?</P></BODY></HTML> Wed, 16 Jul 2014 07:32:14 GMT https://community.qlik.com/t5/QlikView/count-for-a-certain-selected-year-month/m-p/683473#M1078919 2014-07-16T07:32:14Z Re: count for a certain selected year/month https://community.qlik.com/t5/QlikView/count-for-a-certain-selected-year-month/m-p/683474#M1078920 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>sum() is an aggregation function as is avg() - you can't put one around the other afaIk. Try</P><P>&gt;&gt;&gt; aggr(sum(weight), month) &lt;&lt;&lt;</P><P>instead.</P><P>HTH</P><P></P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Wed, 16 Jul 2014 07:47:27 GMT https://community.qlik.com/t5/QlikView/count-for-a-certain-selected-year-month/m-p/683474#M1078920 datanibbler 2014-07-16T07:47:27Z