Discussion board where members can learn more about Qlik Sense App Development and Usage.
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 :
Do you have an idea ?
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
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.