Need help to solve this duplicate row issue

[praveensprabhu]

Hello Experts,

I'm encountering an issue in QlikView involving a straight table. The problem arises from certain part numbers having multiple entries in the cut_in_yr column, specifically two different years. This is causing unintended duplication of other values in the table.
The duplication is particularly problematic when users export the data to Excel, as it's affecting the accuracy of totals. I'm seeking a solution to eliminate these duplicates and ensure the data integrity, especially for Excel exports.
Can you suggest an effective approach to resolve this duplication issue while maintaining the correct representation of data?

In the above screenshot, the blue colored column Cut in Year is having two years, which is needed, but other non-coloured columns values are getting duplicated. How can i avoid this? 

 

[rubenmarin]

Hi, it looks like a model issue, or maybe a logic issue.

What is happening is that the data of the columns in white has a relationship with all the values of the columns in blue, so Qlik shows all the relations, if there is only one value on the white columns the sum of the values on qlik will returns the same result, as there is only one value, but related with both rows, it's not duplicated... and if the sum doubles, it's because the dte is really duplicated in the data model and will need a differnt solution.

If you don't want to show data for certain rows you'll need to set a condition, which one of the rows should not be shown? all the row or only some columns has to be hidden?

The condition should work for all the possible selections the user can do.