topic Sum Values Irrespective of one field in QlikView https://community.qlik.com/t5/QlikView/Sum-Values-Irrespective-of-one-field/m-p/1796824#M1211337 <P>Hello, I want to have the Market share of each company by country, and I don't know how to do this calculation using set analysis.</P><P>Any suggestions?</P><P>Table1: Contains the total amount by company and country</P><TABLE><TBODY><TR><TD>Country</TD><TD>Company1</TD><TD>Company2</TD><TD>Company3</TD><TD>Total</TD></TR><TR><TD>C1</TD><TD>3000</TD><TD>2500</TD><TD>900</TD><TD>6400</TD></TR><TR><TD>C2</TD><TD>4000</TD><TD>3000</TD><TD>1500</TD><TD>8500</TD></TR><TR><TD>C3</TD><TD>3500</TD><TD>1400</TD><TD>800</TD><TD>5700</TD></TR><TR><TD>C4</TD><TD>2000</TD><TD>1000</TD><TD>800</TD><TD>3800</TD></TR><TR><TD>C5</TD><TD>6000</TD><TD>4500</TD><TD>2600</TD><TD>13100</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I want is to have a table like the following, which contains the amount of each cell in table1 over the total by country</P><P>Table2:</P><TABLE><TBODY><TR><TD>Country</TD><TD>Company1</TD><TD>Company2</TD><TD>Company3</TD></TR><TR><TD>C1</TD><TD>47%</TD><TD>39%</TD><TD>14%</TD></TR><TR><TD>C2</TD><TD>47%</TD><TD>35%</TD><TD>18%</TD></TR><TR><TD>C3</TD><TD>61%</TD><TD>25%</TD><TD>14%</TD></TR><TR><TD>C4</TD><TD>53%</TD><TD>26%</TD><TD>21%</TD></TR><TR><TD>C5</TD><TD>46%</TD><TD>34%</TD><TD>20%</TD></TR></TBODY></TABLE> Mon, 05 Apr 2021 09:02:10 GMT p_1 2021-04-05T09:02:10Z Sum Values Irrespective of one field https://community.qlik.com/t5/QlikView/Sum-Values-Irrespective-of-one-field/m-p/1796824#M1211337 <P>Hello, I want to have the Market share of each company by country, and I don't know how to do this calculation using set analysis.</P><P>Any suggestions?</P><P>Table1: Contains the total amount by company and country</P><TABLE><TBODY><TR><TD>Country</TD><TD>Company1</TD><TD>Company2</TD><TD>Company3</TD><TD>Total</TD></TR><TR><TD>C1</TD><TD>3000</TD><TD>2500</TD><TD>900</TD><TD>6400</TD></TR><TR><TD>C2</TD><TD>4000</TD><TD>3000</TD><TD>1500</TD><TD>8500</TD></TR><TR><TD>C3</TD><TD>3500</TD><TD>1400</TD><TD>800</TD><TD>5700</TD></TR><TR><TD>C4</TD><TD>2000</TD><TD>1000</TD><TD>800</TD><TD>3800</TD></TR><TR><TD>C5</TD><TD>6000</TD><TD>4500</TD><TD>2600</TD><TD>13100</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I want is to have a table like the following, which contains the amount of each cell in table1 over the total by country</P><P>Table2:</P><TABLE><TBODY><TR><TD>Country</TD><TD>Company1</TD><TD>Company2</TD><TD>Company3</TD></TR><TR><TD>C1</TD><TD>47%</TD><TD>39%</TD><TD>14%</TD></TR><TR><TD>C2</TD><TD>47%</TD><TD>35%</TD><TD>18%</TD></TR><TR><TD>C3</TD><TD>61%</TD><TD>25%</TD><TD>14%</TD></TR><TR><TD>C4</TD><TD>53%</TD><TD>26%</TD><TD>21%</TD></TR><TR><TD>C5</TD><TD>46%</TD><TD>34%</TD><TD>20%</TD></TR></TBODY></TABLE> Mon, 05 Apr 2021 09:02:10 GMT https://community.qlik.com/t5/QlikView/Sum-Values-Irrespective-of-one-field/m-p/1796824#M1211337 p_1 2021-04-05T09:02:10Z Re: Sum Values Irrespective of one field https://community.qlik.com/t5/QlikView/Sum-Values-Irrespective-of-one-field/m-p/1796833#M1211338 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/128873">@p_1</a>&nbsp; if your data input is like :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_0-1617616238568.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52347i9F4BF4B3B24A11B8/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_Zarra_0-1617616238568.png" alt="Taoufiq_Zarra_0-1617616238568.png" /></span></P><P>you can use pivot table with:</P><P>dimension: country and company</P><P>measure :</P><LI-CODE lang="python">sum(Value)/sum(Total&lt;Country&gt; Value)</LI-CODE><P>&nbsp;</P><P>output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_1-1617616293796.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52348i892B2196FF7D1AE8/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_Zarra_1-1617616293796.png" alt="Taoufiq_Zarra_1-1617616293796.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 05 Apr 2021 09:51:46 GMT https://community.qlik.com/t5/QlikView/Sum-Values-Irrespective-of-one-field/m-p/1796833#M1211338 Taoufiq_Zarra 2021-04-05T09:51:46Z Re: Sum Values Irrespective of one field https://community.qlik.com/t5/QlikView/Sum-Values-Irrespective-of-one-field/m-p/1796846#M1211340 <P>Thank You&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/56648">@Taoufiq_Zarra</a>&nbsp;, if i want to add year to my set analysis expression how should i write it?</P><P>sum({&lt;year = {2020}&gt;} Value) /&nbsp;sum({&lt;year = {2020}, Country&gt;} total Value)?</P> Mon, 05 Apr 2021 10:49:08 GMT https://community.qlik.com/t5/QlikView/Sum-Values-Irrespective-of-one-field/m-p/1796846#M1211340 p_1 2021-04-05T10:49:08Z