topic Re: Sum for each number expression in QlikView https://community.qlik.com/t5/QlikView/Sum-for-each-number-expression/m-p/1344509#M837825 <HTML><HEAD></HEAD><BODY><P>Hi please share sample app</P></BODY></HTML> Mon, 15 May 2017 09:52:37 GMT qlikview979 2017-05-15T09:52:37Z Sum for each number expression https://community.qlik.com/t5/QlikView/Sum-for-each-number-expression/m-p/1344508#M837824 <HTML><HEAD></HEAD><BODY><P>I'm trying to get a total sum of the total price column but I have some duplicate fields and only want to pick up one 'Total Price' amount per 'Invoice Number'. For instance, for invoice number 14735 there are 3 different fields with the value 1064.4 but I only want to use one of them in the sum expression.</P><P></P><P>Any ideas as to what expression I could use?</P><P></P><P>Thanks</P><P><IMG alt="expression.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163349_expression.PNG" style="font-size: 10pt; height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-for-each-number-expression/m-p/1344508#M837824 khaycock 2020-11-25T16:16:04Z Re: Sum for each number expression https://community.qlik.com/t5/QlikView/Sum-for-each-number-expression/m-p/1344509#M837825 <HTML><HEAD></HEAD><BODY><P>Hi please share sample app</P></BODY></HTML> Mon, 15 May 2017 09:52:37 GMT https://community.qlik.com/t5/QlikView/Sum-for-each-number-expression/m-p/1344509#M837825 qlikview979 2017-05-15T09:52:37Z Re: Sum for each number expression https://community.qlik.com/t5/QlikView/Sum-for-each-number-expression/m-p/1344510#M837826 <HTML><HEAD></HEAD><BODY><P>This should do it:</P><P><EM>=Sum(Aggr(Only([Total Price]), [Invoice Number]))</EM></P><P></P><P>I suggest that you re-examine the data model to create a table in which these amounts are not duplicted and possibly amend the model/front end so that you are not making spurious duplicates from incorrectlty associated dimensions.</P></BODY></HTML> Mon, 15 May 2017 09:58:15 GMT https://community.qlik.com/t5/QlikView/Sum-for-each-number-expression/m-p/1344510#M837826 jonathandienst 2017-05-15T09:58:15Z Re: Sum for each number expression https://community.qlik.com/t5/QlikView/Sum-for-each-number-expression/m-p/1344511#M837827 <HTML><HEAD></HEAD><BODY><P>Here is one. Thanks.</P></BODY></HTML> Mon, 15 May 2017 09:58:29 GMT https://community.qlik.com/t5/QlikView/Sum-for-each-number-expression/m-p/1344511#M837827 khaycock 2017-05-15T09:58:29Z