Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

victor_greffet
New Contributor III

count duplicates in a column

Hi community,

Still stuck on the problem related here  :

Remove duplicates

I'm trying to count the number of duplications that i have in my database for one field, I mean after loading my DATA, adding a column like that :

ReferenceDuplicationNumber
Ref 14
Ref 14
Ref 14
Ref 21
Ref14
Ref 31
Ref 41
Ref 51
Ref 61
....

Do you have an idea ?

Thanks,

Victor

Tags (1)
2 Replies
sureshqv
Esteemed Contributor III

Re: count duplicates in a column

In qlikview when you read the fields if there is same records it will show single value if it is not associated with any value or field. Also if you count the field you get its count result.

like see the difference in the script results


Count(Field)


Or


Count(Distinct Field)

victor_greffet
New Contributor III

Re: count duplicates in a column

Thks for your reply,

Load distinct Reference or load Reference is the same for me because this is not exactly the same line in duplication, the ref is the same but I can have additionnal values in other field.

In the case below, load distinct Ref would give me 2 line. and I want to keep only the yellow line.

Capture.PNG