Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

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
Highlighted
Valued Contributor

Re: How to remove Duplicated rows from Chart Table

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

Highlighted
Partner
Partner

Re: How to remove Duplicated rows from Chart Table

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.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
New Contributor III

Re: How to remove Duplicated rows from Chart Table

Measures: rowno(total) 

Highlighted
Valued Contributor

Re: How to remove Duplicated rows from Chart Table

Hi Keitaru

What @Vegar  said is probably what is happening then.

Regards,

Mauritz

Highlighted
Partner
Partner

Re: How to remove Duplicated rows from Chart Table

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.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
New Contributor III

Re: How to remove Duplicated rows from Chart Table

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.

Highlighted
New Contributor III

Re: How to remove Duplicated rows from Chart Table

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