https://community.qlik.com/t5/QlikView/Set-Analysis-and-Aggregation/m-p/1550534#M440232 <P><span class="lia-inline-image-display-wrapper lia-image-align-right" image-alt="gt.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6999i1BD75BE69B2E4472/image-size/large?v=v2&amp;px=999" role="button" title="gt.PNG" alt="gt.PNG" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>I've got a count of the number of Business Units and Companies (far right). What I want to do is aggregate these up by the VAT Number (far left). So for this example it should be 44 Business Companies on each row (instead of 40, 3 and 1). PFA the working example. Any help would be appreciated.</P> Sat, 16 Nov 2024 04:18:32 GMT shane_spencer 2024-11-16T04:18:32Z https://community.qlik.com/t5/QlikView/Set-Analysis-and-Aggregation/m-p/1550534#M440232 <P><span class="lia-inline-image-display-wrapper lia-image-align-right" image-alt="gt.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6999i1BD75BE69B2E4472/image-size/large?v=v2&amp;px=999" role="button" title="gt.PNG" alt="gt.PNG" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>I've got a count of the number of Business Units and Companies (far right). What I want to do is aggregate these up by the VAT Number (far left). So for this example it should be 44 Business Companies on each row (instead of 40, 3 and 1). PFA the working example. Any help would be appreciated.</P> Sat, 16 Nov 2024 04:18:32 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Aggregation/m-p/1550534#M440232 shane_spencer 2024-11-16T04:18:32Z https://community.qlik.com/t5/QlikView/Set-Analysis-and-Aggregation/m-p/1550546#M440233 <P>Sound like you need a partial total. No need for set analysis or Aggr(). Something like:</P><P><EM>Count(TOTAL &lt;[VAT Number]&gt; ......</EM></P> Thu, 28 Feb 2019 14:10:42 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Aggregation/m-p/1550546#M440233 jonathandienst 2019-02-28T14:10:42Z