topic Re: How to calculate 'Sales share' expression: Set or Aggr? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-Sales-share-expression-Set-or-Aggr/m-p/1380660#M814157 <HTML><HEAD></HEAD><BODY><P>May be you need this</P><P></P><P><STRONG>Sum([Sales (L)])/Sum(Total {&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Manufactures, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Brands</SPAN></SPAN>&gt;} [Sales (L)])*100</STRONG></P></BODY></HTML> Wed, 20 Sep 2017 15:52:31 GMT sunny_talwar 2017-09-20T15:52:31Z How to calculate 'Sales share' expression: Set or Aggr? https://community.qlik.com/t5/QlikView/How-to-calculate-Sales-share-expression-Set-or-Aggr/m-p/1380658#M814155 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Experts - Kindly find attached my qvw file..</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a simple monthly sales data. So, I need to calculate Manufactures share by month. I have tried with expression like <SPAN style="color: #ff0000;">=sum(Sales)/sum(Total Sales)*100</SPAN>, It works fine when i selected all Manufactures or Brands. But if i select 2 or 3 Brands then shares has calculated from those 3 brands.</P><P></P><P>I am sorry about my poor English. I have prepared a template with my QVW file.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Sales-share-expression-Set-or-Aggr/m-p/1380658#M814155 muujguu21 2020-11-25T16:16:04Z Re: How to calculate 'Sales share' expression: Set or Aggr? https://community.qlik.com/t5/QlikView/How-to-calculate-Sales-share-expression-Set-or-Aggr/m-p/1380659#M814156 <HTML><HEAD></HEAD><BODY><P>Looks like working. What is the issue?</P></BODY></HTML> Wed, 20 Sep 2017 15:35:13 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Sales-share-expression-Set-or-Aggr/m-p/1380659#M814156 Anil_Babu_Samineni 2017-09-20T15:35:13Z Re: How to calculate 'Sales share' expression: Set or Aggr? https://community.qlik.com/t5/QlikView/How-to-calculate-Sales-share-expression-Set-or-Aggr/m-p/1380660#M814157 <HTML><HEAD></HEAD><BODY><P>May be you need this</P><P></P><P><STRONG>Sum([Sales (L)])/Sum(Total {&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Manufactures, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Brands</SPAN></SPAN>&gt;} [Sales (L)])*100</STRONG></P></BODY></HTML> Wed, 20 Sep 2017 15:52:31 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Sales-share-expression-Set-or-Aggr/m-p/1380660#M814157 sunny_talwar 2017-09-20T15:52:31Z