Discussion board where members can get started with Qlik Sense.
I trying to count duplicate by categories in my data, here is an example :
In this data, I want to count duplicates per machine. The expected result is suposed to be :
Can someone help me achieve this results, please ?
Go to Solution.
try this expression:
View solution in original post
Thank you for the quick reply.
I tried your formula but it did not work. I am supposed to get the value 2 for the first two A, because there two A Incident duplicate on machine 1.
Edit : After rechecking the results, the formula is the good one. But in the table, Qlik Sense have erased the duplicated rows that share the same value for Incident, Machine and NumSerie.
Yes, I know.
that is why i added rowno() as Row to my test script and used Row as a further dimension!