https://community.qlik.com/t5/QlikView/Qlikview-sum-function-duplicating-value/m-p/1703191#M592309 <P>Hello,</P><P>&nbsp;</P><P>I am baffled by the Qlikview sum expression, please see screenhshot below. Value A is duplicated when used in the sum function however the Avg gives the right amount. I have included a table box and a graph for reference.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="skzwane01_0-1589826133855.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33896i5CB040CD9DB785CE/image-size/medium?v=v2&amp;px=400" role="button" title="skzwane01_0-1589826133855.png" alt="skzwane01_0-1589826133855.png" /></span></P><P>&nbsp;</P><P>I dont know what could be the problem. Please assist. Thanks</P> Sat, 16 Nov 2024 00:39:02 GMT skzwane01 2024-11-16T00:39:02Z https://community.qlik.com/t5/QlikView/Qlikview-sum-function-duplicating-value/m-p/1703191#M592309 <P>Hello,</P><P>&nbsp;</P><P>I am baffled by the Qlikview sum expression, please see screenhshot below. Value A is duplicated when used in the sum function however the Avg gives the right amount. I have included a table box and a graph for reference.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="skzwane01_0-1589826133855.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33896i5CB040CD9DB785CE/image-size/medium?v=v2&amp;px=400" role="button" title="skzwane01_0-1589826133855.png" alt="skzwane01_0-1589826133855.png" /></span></P><P>&nbsp;</P><P>I dont know what could be the problem. Please assist. Thanks</P> Sat, 16 Nov 2024 00:39:02 GMT https://community.qlik.com/t5/QlikView/Qlikview-sum-function-duplicating-value/m-p/1703191#M592309 skzwane01 2024-11-16T00:39:02Z https://community.qlik.com/t5/QlikView/Qlikview-sum-function-duplicating-value/m-p/1703194#M592310 <P>hi&nbsp;</P><P>it means you have the row duplicated in the data, put all the fields in the table inside the table box and see which fields create the duplication</P> Mon, 18 May 2020 18:31:37 GMT https://community.qlik.com/t5/QlikView/Qlikview-sum-function-duplicating-value/m-p/1703194#M592310 lironbaram 2020-05-18T18:31:37Z