topic Re: Aggregate Function not working in QlikView https://community.qlik.com/t5/QlikView/Aggregate-Function-not-working/m-p/393641#M146770 <HTML><HEAD></HEAD><BODY><P>The proper syntax can be found in the help file. The proper usage isn't. You may want to read <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr">this blog post</A> and the linked documents.</P></BODY></HTML> Wed, 22 May 2013 13:06:51 GMT Gysbert_Wassenaar 2013-05-22T13:06:51Z Aggregate Function not working https://community.qlik.com/t5/QlikView/Aggregate-Function-not-working/m-p/393640#M146769 <HTML><HEAD></HEAD><BODY><P>I have a chart that contains four columns:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Channel</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Division</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Buying Stores</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Eligible Stores</P><P></P><P>I would like to count or aggregate Eligible Stores per channel, and per division.</P><P></P><P>I'm using the aggregate function but it does not return a number when the Buying Stores column is 0. The calculation comes back blank or with a '-' entry.</P><P></P><P>Where can i find the proper syntax for the Aggr function?</P><P></P><P>Below is my formula.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(eTotalEligibleStoresProduct)</EM></STRONG><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Channel Description]</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Division]</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></P></BODY></HTML> Tue, 21 May 2013 21:53:10 GMT https://community.qlik.com/t5/QlikView/Aggregate-Function-not-working/m-p/393640#M146769 2013-05-21T21:53:10Z Re: Aggregate Function not working https://community.qlik.com/t5/QlikView/Aggregate-Function-not-working/m-p/393641#M146770 <HTML><HEAD></HEAD><BODY><P>The proper syntax can be found in the help file. The proper usage isn't. You may want to read <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr">this blog post</A> and the linked documents.</P></BODY></HTML> Wed, 22 May 2013 13:06:51 GMT https://community.qlik.com/t5/QlikView/Aggregate-Function-not-working/m-p/393641#M146770 Gysbert_Wassenaar 2013-05-22T13:06:51Z