topic Re: How make this sum in QlikView https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827228#M1043425 <HTML><HEAD></HEAD><BODY><P>You don't need to add dimension. Use Tresesco's suggestion below</P></BODY></HTML> Fri, 28 Nov 2014 07:09:22 GMT anbu1984 2014-11-28T07:09:22Z How make this sum https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827223#M1043420 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>Can i have help please.</P><P>I want to make the sum of NBTEU for each REFCONT.</P><P>The sum must be 2 because i have two different&nbsp; REFCONT.</P><P>How can i do it.</P><P></P><P></P><P>Best's regads</P></BODY></HTML> Fri, 28 Nov 2014 06:37:24 GMT https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827223#M1043420 2014-11-28T06:37:24Z Re: How make this sum https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827224#M1043421 <HTML><HEAD></HEAD><BODY><P>Add <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">REFCONT as dimension </SPAN></P></BODY></HTML> Fri, 28 Nov 2014 06:52:39 GMT https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827224#M1043421 anbu1984 2014-11-28T06:52:39Z Re: How make this sum https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827225#M1043422 <HTML><HEAD></HEAD><BODY><P>How can i do it, please?</P></BODY></HTML> Fri, 28 Nov 2014 06:58:54 GMT https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827225#M1043422 2014-11-28T06:58:54Z Re: How make this sum https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827226#M1043423 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>=Sum( Aggr( sum( <STRONG>DISTINCT</STRONG> NBTEU),REFCONT))</P></BODY></HTML> Fri, 28 Nov 2014 06:59:09 GMT https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827226#M1043423 tresB 2014-11-28T06:59:09Z Re: How make this sum https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827227#M1043424 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try with this</P><P></P><P><EM>=Sum( Aggr( Sum(DISTINCT&nbsp; NBTEU ), REFCONT ) )</EM></P><P></P><P>And aggregate the rows in the expression no need to add the dimension.</P><P></P><P>Anand</P></BODY></HTML> Fri, 28 Nov 2014 07:08:12 GMT https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827227#M1043424 its_anandrjs 2014-11-28T07:08:12Z Re: How make this sum https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827228#M1043425 <HTML><HEAD></HEAD><BODY><P>You don't need to add dimension. Use Tresesco's suggestion below</P></BODY></HTML> Fri, 28 Nov 2014 07:09:22 GMT https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827228#M1043425 anbu1984 2014-11-28T07:09:22Z Re: How make this sum https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827229#M1043426 <HTML><HEAD></HEAD><BODY><P>Hi Destin,</P><P></P><P>I think your requirement is without the dimension then try to write like</P><P></P><P><EM>=Sum( Aggr( Sum(DISTINCT&nbsp; NBTEU ), REFCONT ) )</EM></P><P><EM><BR /></EM></P><P>Tresesco and i suggest other wise add the dimension in the chart, also try do not use dimension in the gauge chart.</P><P><EM><BR /></EM></P><P>Regards</P><P>Anand</P></BODY></HTML> Fri, 28 Nov 2014 08:32:53 GMT https://community.qlik.com/t5/QlikView/How-make-this-sum/m-p/827229#M1043426 its_anandrjs 2014-11-28T08:32:53Z