topic count duplicates in a column in App Development

count duplicates in a column

victor_greffet — Wed, 22 Dec 2021 15:42:54 GMT

Hi community,

Still stuck on the problem related here :

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

Re: count duplicates in a column

Chanty4u — Fri, 17 Nov 2017 13:53:50 GMT

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)

Count(Distinct Field)

Re: count duplicates in a column

victor_greffet — Fri, 17 Nov 2017 14:13:09 GMT

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.