topic Re: Aggregate Percentage in QlikView https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573493#M213621 <HTML><HEAD></HEAD><BODY><P>Great Thanks, Working now</P></BODY></HTML> Wed, 12 Feb 2014 09:41:35 GMT 2014-02-12T09:41:35Z Aggregate Percentage https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573489#M213617 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to show the percentage of a field with three distinctions.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Company </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Division</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>=sum(sales)</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Total Company Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A1</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">55</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A2</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">55</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A3</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">55</TD></TR></TBODY></TABLE><P></P><P></P><P>At the moment when I calculate the total using the expression&nbsp; <SPAN style="color: #0000ff; font-size: 10pt;">=aggr</SPAN><SPAN style="font-size: 10pt;">(<SPAN style="color: #0000ff;">sum</SPAN>(<SPAN style="color: #800000;">Sales</SPAN>),<SPAN style="color: #800000;">Company</SPAN>) , I am only getting the total company sales for one division. </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">How can I get it for all?? So I can then work out the percentage sales as a total?</SPAN></P><P></P></BODY></HTML> Wed, 12 Feb 2014 09:34:46 GMT https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573489#M213617 2014-02-12T09:34:46Z Re: Aggregate Percentage https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573490#M213618 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P><SPAN style="color: #0000ff; font-size: 10pt;">aggr</SPAN><SPAN style="font-size: 10pt;">(<SPAN style="color: #0000ff;">sum</SPAN>(Total <SPAN style="color: #800000;">Sales</SPAN>),<SPAN style="color: #800000;">Company</SPAN>)</SPAN></P></BODY></HTML> Wed, 12 Feb 2014 09:37:17 GMT https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573490#M213618 2014-02-12T09:37:17Z Re: Aggregate Percentage https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573491#M213619 <HTML><HEAD></HEAD><BODY><P>You should not use Aggr() for this. You should use the total qualifier:</P><P></P><P>The total sales, entire selection: Sum( total sales )</P><P>The total sales, within company: Sum( total &lt;Company&gt; sales )</P><P></P><P>So your percentage should be calculated through</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum( sales ) / Sum( total &lt;Company&gt; sales )</P><P></P><P>HIC</P></BODY></HTML> Wed, 12 Feb 2014 09:39:29 GMT https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573491#M213619 hic 2014-02-12T09:39:29Z Re: Aggregate Percentage https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573492#M213620 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P>sum(<SPAN style="color: #800000; font-size: 10pt;">Sales</SPAN>)/SUM(TOTAL {1} <SPAN style="color: #800000; font-size: 10pt;">Sales</SPAN>)</P></BODY></HTML> Wed, 12 Feb 2014 09:41:06 GMT https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573492#M213620 2014-02-12T09:41:06Z Re: Aggregate Percentage https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573493#M213621 <HTML><HEAD></HEAD><BODY><P>Great Thanks, Working now</P></BODY></HTML> Wed, 12 Feb 2014 09:41:35 GMT https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573493#M213621 2014-02-12T09:41:35Z Re: Aggregate Percentage https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573494#M213622 <HTML><HEAD></HEAD><BODY><P>See also <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/09/09/aggregation-scope">The Aggregation Scope</A> and <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/11/when-should-the-aggr-function-not-be-used">When should the Aggr() function NOT be used?</A></P><P></P><P>HIC</P></BODY></HTML> Wed, 12 Feb 2014 09:45:33 GMT https://community.qlik.com/t5/QlikView/Aggregate-Percentage/m-p/573494#M213622 hic 2014-02-12T09:45:33Z