topic Re: I can't get the sum function to work with duplicate values in App Development https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826133#M67932 <P>Assuming Value is a field taken from the same table as Mes Documento, it should work and sum correctly. If they are from two separate tables this may be a case where there's actually only one Value to sum, and it's being displayed twice because you put it in the same table with a field from a different table? Providing sample data would help understand the situation here, I think.</P> Mon, 02 Aug 2021 16:17:33 GMT Or 2021-08-02T16:17:33Z I can't get the sum function to work with duplicate values https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826068#M67921 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.PNG" style="width: 480px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59540i858724148309061F/image-size/large?v=v2&amp;px=999" role="button" title="1.PNG" alt="1.PNG" /></span></P><P>Putting it in automatic totals doesn't work and I can't use it in a pivot table. I need it to automatically do the sum of all the values.</P><P>Putting it in KPI doesn't work for me either. any ideas?</P> Mon, 02 Aug 2021 12:21:37 GMT https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826068#M67921 FcoSamuel 2021-08-02T12:21:37Z Re: I can't get the sum function to work with duplicate values https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826085#M67925 <P>Write your formula so that it sums up correctly. Without knowing what the formula is, it's impossible to try and help you correct it.</P> Mon, 02 Aug 2021 13:16:04 GMT https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826085#M67925 Or 2021-08-02T13:16:04Z Re: I can't get the sum function to work with duplicate values https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826090#M67927 <P>sum(value)</P> Mon, 02 Aug 2021 13:35:00 GMT https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826090#M67927 FcoSamuel 2021-08-02T13:35:00Z Re: I can't get the sum function to work with duplicate values https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826133#M67932 <P>Assuming Value is a field taken from the same table as Mes Documento, it should work and sum correctly. If they are from two separate tables this may be a case where there's actually only one Value to sum, and it's being displayed twice because you put it in the same table with a field from a different table? Providing sample data would help understand the situation here, I think.</P> Mon, 02 Aug 2021 16:17:33 GMT https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826133#M67932 Or 2021-08-02T16:17:33Z Re: I can't get the sum function to work with duplicate values https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826214#M67941 <P>They are in different tables. It is very likely a model / relationship problem with the tables just as I was afraid.</P> Tue, 03 Aug 2021 06:34:49 GMT https://community.qlik.com/t5/App-Development/I-can-t-get-the-sum-function-to-work-with-duplicate-values/m-p/1826214#M67941 FcoSamuel 2021-08-03T06:34:49Z