topic Aggregation in QlikView https://community.qlik.com/t5/QlikView/Aggregation/m-p/1267138#M866986 <HTML><HEAD></HEAD><BODY><P>aggr(sum({&lt; [Control Description], Country ,[Fiscal Year Month]={'2016-11'} &gt;} [Record Count]), Country)) &lt; 300</P><P></P><P>Control&nbsp;&nbsp;&nbsp;&nbsp; Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Record Count</P><P>X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 365</P><P>Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 271</P><P>Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; France&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 371</P><P></P><P>Am I right in assuming that my result would be France and UK?</P><P></P><P>=IF(</P><P>aggr(sum({&lt; [Control Description], Country ,[Fiscal Year Month]={'2016-11'} &gt;} [Record Count]), Country)) &lt; 300</P><P>Concat(Country, ' is greater than 300' &amp; chr(13)),<BR /> <BR />&nbsp;&nbsp; Concat(Country, ' is less than 300' &amp; chr(13)))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bobbydave 2020-11-25T16:16:04Z Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/1267138#M866986 <HTML><HEAD></HEAD><BODY><P>aggr(sum({&lt; [Control Description], Country ,[Fiscal Year Month]={'2016-11'} &gt;} [Record Count]), Country)) &lt; 300</P><P></P><P>Control&nbsp;&nbsp;&nbsp;&nbsp; Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Record Count</P><P>X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 365</P><P>Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 271</P><P>Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; France&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 371</P><P></P><P>Am I right in assuming that my result would be France and UK?</P><P></P><P>=IF(</P><P>aggr(sum({&lt; [Control Description], Country ,[Fiscal Year Month]={'2016-11'} &gt;} [Record Count]), Country)) &lt; 300</P><P>Concat(Country, ' is greater than 300' &amp; chr(13)),<BR /> <BR />&nbsp;&nbsp; Concat(Country, ' is less than 300' &amp; chr(13)))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/1267138#M866986 bobbydave 2020-11-25T16:16:04Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/1267139#M866987 <HTML><HEAD></HEAD><BODY><P>Figured it out</P><P></P><P>=Concat(</P><P> if(</P><P> aggr(</P><P>&nbsp; sum({&lt; [Control Description], Country ,[Fiscal Year Month]={'2016-11'} &gt;} [Record Count]), </P><P>&nbsp;&nbsp; Country)&gt;300,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Country),', ')</P></BODY></HTML> Thu, 15 Dec 2016 14:43:22 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/1267139#M866987 bobbydave 2016-12-15T14:43:22Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/1267140#M866988 <HTML><HEAD></HEAD><BODY><P>Another options:</P><P></P><P><STRONG>Concat(DISTINCT {&lt;Country = {"=S<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">um({&lt;[Control Description], Country, [Fiscal Year Month]={'2016-11'}&gt;} [Record Count]) </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&gt; 300</SPAN></STRONG><SPAN style="font-size: 10pt;"><STRONG>"}&gt;} Country, ', ')</STRONG></SPAN></P></BODY></HTML> Thu, 15 Dec 2016 14:49:53 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/1267140#M866988 sunny_talwar 2016-12-15T14:49:53Z