Solving data duplication issue

[Iwin]

Hi All,

I have following data duplication issue 

Key fields here are PO Doc and po item no.As you can see data is duplicating for the keys.

In this case sum of quantity is showing a value where PR NO is blank. Where the PR NO is present,the Quantity is showing as 0.Issue is at source level currently but we are trying to solve in Qlik as a temporary solution before it gets rectified at source.Also , not all records are getting duplicated.I want to solve the issue where duplication occurs on the key fields .

The ideal scenario is as follows:

How can i resolve this?

[Mario_ES]

Try a Group By

[Iwin]

Hi @Mario_ES ,there are additional fields in qvd and when i used group by based on this fields,same issue came.

Also tried linking quantity measure seperately using keyfields and did a group by based on the key fields.But it didnt work.