topic Re: Duplicate Purchase Orders in QlikView https://community.qlik.com/t5/QlikView/Duplicate-Purchase-Orders/m-p/1360800#M831291 <HTML><HEAD></HEAD><BODY><P>Perfect, THANKS!!!!</P></BODY></HTML> Mon, 26 Jun 2017 17:44:35 GMT gfisch13 2017-06-26T17:44:35Z Duplicate Purchase Orders https://community.qlik.com/t5/QlikView/Duplicate-Purchase-Orders/m-p/1360798#M831289 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I'm working with a file of purchase orders where I have all the line items for the purchase order, but each line one has the gross total of the Purchase Order.</P><P></P><P>I want to get to a situation where I have one purchase order and the total amount.</P><P></P><P>This is what I see:</P><P></P><P>PO ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Desc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total</P><P>12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pencils&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.00</P><P>12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pens&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.00</P><P>12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; garbage bags&nbsp;&nbsp;&nbsp;&nbsp; 500.00</P><P>65478&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tickets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200.00</P><P>78963&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; computers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00</P><P>78963&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; software&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00</P><P></P><P>This is what I want:</P><P></P><P>12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.00</P><P>65478&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200.00</P><P>78963&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00</P><P></P><P>Any help is appreciated!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Duplicate-Purchase-Orders/m-p/1360798#M831289 gfisch13 2020-11-25T16:16:04Z Re: Duplicate Purchase Orders https://community.qlik.com/t5/QlikView/Duplicate-Purchase-Orders/m-p/1360799#M831290 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Aggr(Amount, [PO ID]))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Only(Amount), [PO ID]))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Avg(Amount), [PO ID]))</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum(Aggr(Sum(DISTINCT Amount), [PO ID]))</STRONG></P></BODY></HTML> Mon, 26 Jun 2017 17:38:32 GMT https://community.qlik.com/t5/QlikView/Duplicate-Purchase-Orders/m-p/1360799#M831290 sunny_talwar 2017-06-26T17:38:32Z Re: Duplicate Purchase Orders https://community.qlik.com/t5/QlikView/Duplicate-Purchase-Orders/m-p/1360800#M831291 <HTML><HEAD></HEAD><BODY><P>Perfect, THANKS!!!!</P></BODY></HTML> Mon, 26 Jun 2017 17:44:35 GMT https://community.qlik.com/t5/QlikView/Duplicate-Purchase-Orders/m-p/1360800#M831291 gfisch13 2017-06-26T17:44:35Z