Qlikview sum function duplicating value

[skzwane01]

Hello,

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.

I dont know what could be the problem. Please assist. Thanks

[lironbaram · Accepted solution]

hi 

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