topic Re: How to sum the shown values in chart in QlikView https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706631#M672842 <HTML><HEAD></HEAD><BODY><P>not sure i understood your requirement completely, but try enabling show partial sums in Presentation tab.</P></BODY></HTML> Tue, 19 Aug 2014 19:42:30 GMT Anonymous 2014-08-19T19:42:30Z How to sum the shown values in chart https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706630#M672840 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>as you can seen there is a small request for help.</P><P></P><P>How do I sum all the values shown in chart, without suppressed values?</P><P></P><P></P><P>best regards</P></BODY></HTML> Tue, 19 Aug 2014 19:35:26 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706630#M672840 2014-08-19T19:35:26Z Re: How to sum the shown values in chart https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706631#M672842 <HTML><HEAD></HEAD><BODY><P>not sure i understood your requirement completely, but try enabling show partial sums in Presentation tab.</P></BODY></HTML> Tue, 19 Aug 2014 19:42:30 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706631#M672842 Anonymous 2014-08-19T19:42:30Z Re: How to sum the shown values in chart https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706632#M672844 <HTML><HEAD></HEAD><BODY><P>I want to sum all values from first expression, so that I can get something like this</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Size&nbsp;&nbsp; SizeIn%</P><P>Loc1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 10%</P><P>Loc2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; </P><P>Loc3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; </P><P>SuppressedLoc&nbsp;&nbsp;&nbsp; 69</P><P></P><P>so i want to sum the values, excluding suppressed values, to get 10% 40% 50%</P></BODY></HTML> Tue, 19 Aug 2014 19:53:14 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706632#M672844 2014-08-19T19:53:14Z Re: How to sum the shown values in chart https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706633#M672845 <HTML><HEAD></HEAD><BODY><P>hola,</P><P></P><P>Espero me puedas entender,</P><P></P><P>agregar expresion</P><P></P><P>sum(size) / sum(total size)&nbsp;&nbsp; // sizeIn%</P><P></P><P>después realizar<IMG alt="ejemplo_19082014.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/64797_ejemplo_19082014.png" style="width: 620px; height: 308px;" /></P><P></P><P>te debe de quedar algo similar</P><P></P><P><IMG alt="ejemplo2_19082014.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/64798_ejemplo2_19082014.png" /></P><P></P><P>saludos</P></BODY></HTML> Tue, 19 Aug 2014 20:43:36 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706633#M672845 jer_2011 2014-08-19T20:43:36Z Re: How to sum the shown values in chart https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706634#M672847 <HTML><HEAD></HEAD><BODY><P>But when I suppress the&nbsp; location, sum of % is not 100.</P></BODY></HTML> Wed, 20 Aug 2014 12:44:17 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-shown-values-in-chart/m-p/706634#M672847 2014-08-20T12:44:17Z