count duplicates in a column

[victor_greffet]

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 :

Reference	DuplicationNumber
Ref 1	4
Ref 1	4
Ref 1	4
Ref 2	1
Ref1	4
Ref 3	1
Ref 4	1
Ref 5	1
Ref 6	1
....

Do you have an idea ?

Thanks,

Victor

[Chanty4u]

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]

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.