Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Keitaru
Creator
Creator

How to remove Duplicated rows from Chart Table

Found some duplicated data in my Flat Table Chart.

in my Backend data there is no duplicates however when adding the data to a flat table chart, the duplication occursDuplicated.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

As shown in the table image above.

7 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Keitaru

Where are you getting the # field in the first column? The fact that there is a 7 & 8 for your one Incident ID makes it seem as if you do have duplicates.

Regards,

Mauritz

Vegar
MVP
MVP

From my experience, the duplicate rows are is most likely caused by a uncontrolled JOIN in the script. A join where you have more than one occurence of the join keys in one of the tables.
Keitaru
Creator
Creator
Author

Measures: rowno(total) 

Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Keitaru

What @Vegar  said is probably what is happening then.

Regards,

Mauritz

Vegar
MVP
MVP

If you do have a row identifier, then you could check if you have duplicates in a chart/table using the row identifier as an dimension and count([row identifier])-1 as measure. The -1 will let most values become 0 except your duplicate rows.
Keitaru
Creator
Creator
Author

Right now I've limit the number of keys to prevent any synthetic keys from occuring however my main data set is linked to various other table via a single primary key. I was thinking I'd this might be the cause of the issue.

 

Will try your method out see if it works.

Keitaru
Creator
Creator
Author

Nope doesn't seem to work my duplicated row showed as 0 as well based on the unique identifier.