topic Re: Sum while Ignoring selection in QlikView https://community.qlik.com/t5/QlikView/Sum-while-Ignoring-selection/m-p/847240#M995630 <HTML><HEAD></HEAD><BODY><P>If you use set analysis then</P><P></P><P>Sum({$ &lt;myField=&gt;} value) -&gt; with this sysntax you do not consider selectios of the field myField.</P><P>Sum({1} value) -&gt; in this way you do not consider all the selections</P></BODY></HTML> Tue, 30 Jun 2015 08:04:56 GMT alexandros17 2015-06-30T08:04:56Z Sum while Ignoring selection https://community.qlik.com/t5/QlikView/Sum-while-Ignoring-selection/m-p/847239#M995629 <HTML><HEAD></HEAD><BODY><P>Good day all,</P><P></P><P>I am trying to calculate the percentage of GP a selected field contributes to the total GP but do no know how to ignore the selection when calculating the Total GP.</P><P>Thank you for your help.</P></BODY></HTML> Tue, 30 Jun 2015 08:02:01 GMT https://community.qlik.com/t5/QlikView/Sum-while-Ignoring-selection/m-p/847239#M995629 2015-06-30T08:02:01Z Re: Sum while Ignoring selection https://community.qlik.com/t5/QlikView/Sum-while-Ignoring-selection/m-p/847240#M995630 <HTML><HEAD></HEAD><BODY><P>If you use set analysis then</P><P></P><P>Sum({$ &lt;myField=&gt;} value) -&gt; with this sysntax you do not consider selectios of the field myField.</P><P>Sum({1} value) -&gt; in this way you do not consider all the selections</P></BODY></HTML> Tue, 30 Jun 2015 08:04:56 GMT https://community.qlik.com/t5/QlikView/Sum-while-Ignoring-selection/m-p/847240#M995630 alexandros17 2015-06-30T08:04:56Z