topic Re: Percent Sales for Region in QlikView https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241977#M850774 <HTML><HEAD></HEAD><BODY><P>Hi Bacius,</P><P>Is TOTAL a function ?</P><P>Please help.</P><P></P><P>Thanks,</P><P>Sarif</P></BODY></HTML> Tue, 07 Mar 2017 10:57:39 GMT mhmmd_srf 2017-03-07T10:57:39Z Percent Sales for Region https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241975#M850772 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have requirement like below in Qlikview:</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155409_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>The Percent Sum is like Sales for Each Region divided by Sales for all Region.</P><P>Please help.</P><P></P><P>Thanks,</P><P>Sarif</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241975#M850772 mhmmd_srf 2020-11-25T16:16:04Z Re: Percent Sales for Region https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241976#M850773 <HTML><HEAD></HEAD><BODY><P>Maybe:</P><P>Sum(Sales)/Sum(TOTAL Sales)</P></BODY></HTML> Tue, 07 Mar 2017 10:53:24 GMT https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241976#M850773 MindaugasBacius 2017-03-07T10:53:24Z Re: Percent Sales for Region https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241977#M850774 <HTML><HEAD></HEAD><BODY><P>Hi Bacius,</P><P>Is TOTAL a function ?</P><P>Please help.</P><P></P><P>Thanks,</P><P>Sarif</P></BODY></HTML> Tue, 07 Mar 2017 10:57:39 GMT https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241977#M850774 mhmmd_srf 2017-03-07T10:57:39Z Re: Percent Sales for Region https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241978#M850775 <HTML><HEAD></HEAD><BODY><P>Yes.</P><P></P><P>It gives sum of Sales for all Region</P><P></P><P>Regards,</P><P>Prashant </P></BODY></HTML> Tue, 07 Mar 2017 10:59:09 GMT https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241978#M850775 PrashantSangle 2017-03-07T10:59:09Z Re: Percent Sales for Region https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241979#M850776 <HTML><HEAD></HEAD><BODY><P>May be like this,</P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum(total &lt;RGN&gt; Sales)/Sum(TOTAL Sales)</SPAN></P></BODY></HTML> Tue, 07 Mar 2017 11:00:30 GMT https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241979#M850776 muthukumar77 2017-03-07T11:00:30Z Re: Percent Sales for Region https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241980#M850777 <HTML><HEAD></HEAD><BODY><P>TOTAL is a qualifier that helps calculation in chart to disregard dimensions. For detailed explanation read it here: <A href="https://community.qlik.com/message/175870">Keywords : TOTAL, ALL &amp;amp; DISTINCT</A></P></BODY></HTML> Tue, 07 Mar 2017 11:03:29 GMT https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241980#M850777 tresB 2017-03-07T11:03:29Z Re: Percent Sales for Region https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241981#M850778 <HTML><HEAD></HEAD><BODY><P>Or </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>S</EM></SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;"><EM>um(Sales)/Sum(TOTAL &lt;RGN&gt; Sales)</EM></SPAN></P></BODY></HTML> Tue, 07 Mar 2017 11:17:57 GMT https://community.qlik.com/t5/QlikView/Percent-Sales-for-Region/m-p/1241981#M850778 jonathandienst 2017-03-07T11:17:57Z