Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Geostidet
Contributor II
Contributor II

Flag duplicate on a straight table

Hi I am trying to create a field to flag duplicate  on  a straight table the field is a concatenation of 3 fields I do no have access to the back end (Script) to make change on the data model  so I am using this code it woks on just on field but on multiple field concatenate

 

 =if(count(total <ID&Tradedate&Tranno>ID&Tradedate&Tranno)> 1,'Duplicate','unique')

Geostidet_0-1730460258251.png

 

2 Solutions

Accepted Solutions
Kushal_Chawda

@Geostidet  just a little change required

=if(count(total <ID,Tradedate,Tranno> ID&Tradedate&Tranno)> 1,'Duplicate','unique')

View solution in original post

Geostidet
Contributor II
Contributor II
Author

Geostidet_0-1730463038003.png

@Kushal_Chawda thanks so much is it a way to flag the highlighted rows as duplicate regardless of the type  or dir  just taking in consideration ID&Tradedate&Tranno

View solution in original post

4 Replies
Kushal_Chawda

@Geostidet  just a little change required

=if(count(total <ID,Tradedate,Tranno> ID&Tradedate&Tranno)> 1,'Duplicate','unique')

Geostidet
Contributor II
Contributor II
Author

Geostidet_0-1730463038003.png

@Kushal_Chawda thanks so much is it a way to flag the highlighted rows as duplicate regardless of the type  or dir  just taking in consideration ID&Tradedate&Tranno

Kushal_Chawda

@Geostidet  Yeah. It should.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Since you are already grouping by the three fields, I think this could be simplified to count just a single field.

=if(count(total <ID,Tradedate,Tranno> ID)> 1,'Duplicate','unique')

-Rob