https://community.qlik.com/t5/QlikView/Calculate-Relative/m-p/1860952#M1216136 <P>Sum(Quantity) / Sum(total Quantity), perhaps? Not sure if there's any other factors at play here which might require modifying that.</P> Thu, 18 Nov 2021 12:00:12 GMT Or 2021-11-18T12:00:12Z https://community.qlik.com/t5/QlikView/Calculate-Relative/m-p/1860934#M1216135 <P>Hi!</P> <P>i have as dimension Item_Number - and an expression sum(Quantity).</P> <P>I would like to create an additional expression, that shows the relative % of each item number (based on the selection done on item number).&nbsp;</P> <P>Example, here below i selected just 8 different item number - i would like to get the % relative for each item in temrs of quantity.</P> <P>How can be done ?<BR />Thanks!!</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qlikviewaf_0-1637235301135.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66935i3E18151BBD8F5785/image-size/medium?v=v2&amp;px=400" role="button" title="qlikviewaf_0-1637235301135.png" alt="qlikviewaf_0-1637235301135.png" /></span></P> <P>i would like to calculate the column %&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qlikviewaf_1-1637235460979.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66936i4AA97BF1C46F37E0/image-size/medium?v=v2&amp;px=400" role="button" title="qlikviewaf_1-1637235460979.png" alt="qlikviewaf_1-1637235460979.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 18 Nov 2021 11:38:02 GMT https://community.qlik.com/t5/QlikView/Calculate-Relative/m-p/1860934#M1216135 qlikviewaf 2021-11-18T11:38:02Z https://community.qlik.com/t5/QlikView/Calculate-Relative/m-p/1860952#M1216136 <P>Sum(Quantity) / Sum(total Quantity), perhaps? Not sure if there's any other factors at play here which might require modifying that.</P> Thu, 18 Nov 2021 12:00:12 GMT https://community.qlik.com/t5/QlikView/Calculate-Relative/m-p/1860952#M1216136 Or 2021-11-18T12:00:12Z