topic Help with Aggr Function? Market Share. in QlikView https://community.qlik.com/t5/QlikView/Help-with-Aggr-Function-Market-Share/m-p/359275#M493295 <HTML><HEAD></HEAD><BODY><P>I've built a pivot simialr to below and want to calcuate our share of the market.&nbsp; I've ried mutiple AGGR funcitons but cant seem to crack it...so requesting some expert help</P><P></P><P></P><P>In the AGGR column, I'm expecting the Competitor total in the first 3 cells (366,496), and then the Internal products total in the following 3 (43,538). </P><P>Any help will be appreciated.</P><P></P><P>Thanks, Jay</P></BODY></HTML> Fri, 18 May 2012 17:27:28 GMT 2012-05-18T17:27:28Z Help with Aggr Function? Market Share. https://community.qlik.com/t5/QlikView/Help-with-Aggr-Function-Market-Share/m-p/359275#M493295 <HTML><HEAD></HEAD><BODY><P>I've built a pivot simialr to below and want to calcuate our share of the market.&nbsp; I've ried mutiple AGGR funcitons but cant seem to crack it...so requesting some expert help</P><P></P><P></P><P>In the AGGR column, I'm expecting the Competitor total in the first 3 cells (366,496), and then the Internal products total in the following 3 (43,538). </P><P>Any help will be appreciated.</P><P></P><P>Thanks, Jay</P></BODY></HTML> Fri, 18 May 2012 17:27:28 GMT https://community.qlik.com/t5/QlikView/Help-with-Aggr-Function-Market-Share/m-p/359275#M493295 2012-05-18T17:27:28Z Help with Aggr Function? Market Share. https://community.qlik.com/t5/QlikView/Help-with-Aggr-Function-Market-Share/m-p/359276#M493296 <HTML><HEAD></HEAD><BODY><P>If I understood correctly, try this for the share:</P><P></P><P><EM>=sum(Amount) / sum<STRONG>(total&lt;Ownership&gt;</STRONG> Amount)</EM></P></BODY></HTML> Fri, 18 May 2012 17:33:35 GMT https://community.qlik.com/t5/QlikView/Help-with-Aggr-Function-Market-Share/m-p/359276#M493296 swuehl 2012-05-18T17:33:35Z Help with Aggr Function? Market Share. https://community.qlik.com/t5/QlikView/Help-with-Aggr-Function-Market-Share/m-p/359277#M493297 <HTML><HEAD></HEAD><BODY><P>Try Sum(TOTAL &lt;Ownership&gt; Sales) obviously replacing Sales with your own field. </P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Fri, 18 May 2012 17:34:20 GMT https://community.qlik.com/t5/QlikView/Help-with-Aggr-Function-Market-Share/m-p/359277#M493297 Jason_Michaelides 2012-05-18T17:34:20Z Help with Aggr Function? Market Share. https://community.qlik.com/t5/QlikView/Help-with-Aggr-Function-Market-Share/m-p/359278#M493298 <HTML><HEAD></HEAD><BODY><P>Cheers Jason - Thats exactly what I wanted.</P></BODY></HTML> Fri, 18 May 2012 17:36:51 GMT https://community.qlik.com/t5/QlikView/Help-with-Aggr-Function-Market-Share/m-p/359278#M493298 2012-05-18T17:36:51Z