topic Sum or aggr in QlikView https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665034#M474759 <HTML><HEAD></HEAD><BODY><P>Hi, everyone</P><P>It´s possible:</P><P></P><P>VIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DES</P><P>AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P></P><P>I want the sum is only one that is only 20, <A href="https://community.qlik.com/qlik-users/2001">QlikTech Admin</A></P><P></P><P>Sum(DES) = 20</P></BODY></HTML> Wed, 27 Aug 2014 16:21:51 GMT fabio182 2014-08-27T16:21:51Z Sum or aggr https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665034#M474759 <HTML><HEAD></HEAD><BODY><P>Hi, everyone</P><P>It´s possible:</P><P></P><P>VIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DES</P><P>AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P></P><P>I want the sum is only one that is only 20, <A href="https://community.qlik.com/qlik-users/2001">QlikTech Admin</A></P><P></P><P>Sum(DES) = 20</P></BODY></HTML> Wed, 27 Aug 2014 16:21:51 GMT https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665034#M474759 fabio182 2014-08-27T16:21:51Z Re: Sum or aggr https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665035#M474760 <HTML><HEAD></HEAD><BODY><P>I'm not sure I understand the question...&nbsp; Maybe</P><P>sum(distinct DES)</P></BODY></HTML> Wed, 27 Aug 2014 16:24:38 GMT https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665035#M474760 Anonymous 2014-08-27T16:24:38Z Re: Sum or aggr https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665036#M474761 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">VIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DES</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">BB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">In this case, exclude VIN tip BB</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">AA&nbsp; 20</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">BB&nbsp; 20</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">---------------</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40</P></BODY></HTML> Wed, 27 Aug 2014 16:48:52 GMT https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665036#M474761 fabio182 2014-08-27T16:48:52Z Re: Re: Sum or aggr https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665037#M474762 <HTML><HEAD></HEAD><BODY><P>Can do that too:<BR />sum(aggr(sum(distinct DES),VIN))</P><P>See attached</P></BODY></HTML> Wed, 27 Aug 2014 16:58:01 GMT https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665037#M474762 Anonymous 2014-08-27T16:58:01Z Re: Sum or aggr https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665038#M474763 <HTML><HEAD></HEAD><BODY><P>Thanks Michael !!!</P></BODY></HTML> Wed, 27 Aug 2014 17:10:56 GMT https://community.qlik.com/t5/QlikView/Sum-or-aggr/m-p/665038#M474763 fabio182 2014-08-27T17:10:56Z