topic Re: Sum of amont in QlikView https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710206#M1061263 <HTML><HEAD></HEAD><BODY><P>=Sum(Aggr(DISTINCT AMONT_LIGN_BUD,CODE_LIGN_BUD))</P></BODY></HTML> Sat, 27 Sep 2014 10:50:06 GMT anbu1984 2014-09-27T10:50:06Z Sum of amont https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710205#M1061262 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>Can i have help please. I want to have in the Text Object the total amont of AG12 and AG10.</P><P>In fact&nbsp; the amont of</P><P>AG12=50000 </P><P>and</P><P>AG10=40000</P><P></P><P>so the total amont (AG12+AG10)=90000.</P><P></P><P>How can i do that.</P><P></P><P>Best regards.</P></BODY></HTML> Sat, 27 Sep 2014 10:40:53 GMT https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710205#M1061262 2014-09-27T10:40:53Z Re: Sum of amont https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710206#M1061263 <HTML><HEAD></HEAD><BODY><P>=Sum(Aggr(DISTINCT AMONT_LIGN_BUD,CODE_LIGN_BUD))</P></BODY></HTML> Sat, 27 Sep 2014 10:50:06 GMT https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710206#M1061263 anbu1984 2014-09-27T10:50:06Z Re: Sum of amont https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710207#M1061264 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>Think you. It work nomaly with your code.</P><P></P><P>Best regards!</P></BODY></HTML> Sat, 27 Sep 2014 11:30:45 GMT https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710207#M1061264 2014-09-27T11:30:45Z Re: Sum of amont https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710208#M1061268 <HTML><HEAD></HEAD><BODY><P>If you don't have any further queries, please close the thread as answered</P></BODY></HTML> Sat, 27 Sep 2014 11:39:09 GMT https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710208#M1061268 anbu1984 2014-09-27T11:39:09Z Re: Sum of amont https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710209#M1061271 <HTML><HEAD></HEAD><BODY><P>Hi Destin,</P><P></P><P>Try this:</P><P></P><P>=sum( {&lt; CODE_LIGN_BUD = {GA10,GA12}&gt;} distinct AMONT_LIGN_BUD)</P><P></P><P>Nitha</P></BODY></HTML> Sat, 27 Sep 2014 12:55:41 GMT https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710209#M1061271 Anonymous 2014-09-27T12:55:41Z Re: Sum of amont https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710210#M1061272 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>Think you. I will try also your code. In fact <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/anbu1984">anbu1984</A></STRONG> give me a right code.</P><P></P><P>Best regards!</P></BODY></HTML> Sat, 27 Sep 2014 20:15:03 GMT https://community.qlik.com/t5/QlikView/Sum-of-amont/m-p/710210#M1061272 2014-09-27T20:15:03Z