How to get Duplicate values Summary.. as Below

[Anonymous]

Hi,

I have ID Column, I need to count the duplicate values and for those values required summary.. Please find the attached excel for the same. Count Formula in excel is 'COUNTIF($A$2:$A$20,A2)'

ID	Count
15071698	4
16639602	2
16656750	1
16650963	1
16654249	1
16639603	2
16639603	2
16639598	1
16647113	1
16644860	1
15071698	4
16651093	1
16649754	1
16651689	1
15071698	4
16639609	1
16639608	1
15071698	4
16639602	2

Result should be as below

Row Labels	Count of ID
1	11
2	4
4	4
Grand Total	19

Thanks in Advance......

[settu_periasamy]

Hi,

Just Load your excel file into QV.

Put ID as dimension, count(ID) as Expression.

I think you will get the desired result.

[prma7799]

Like this

[Anonymous]

Thanks for Reply..

I need to count the duplicate values in script level, in my data there was no 'Count' column.

Regards,

Rafee

[settu_periasamy · Accepted solution]

Try this.

Load Count(ID) as ID from Table Group by ID;.

In the Chart, Dimension as ID, sum(ID) as Expression.

[shiveshsingh]

In your excel, one sheet is having count and ID column,

so you need to put Count column as dimension and count(ID) as expression.

Refer attached app

[dinuwanbr]

Hi,

Check this. It has both the way counting. from Expressions and scripting.

Rgds,

Dinu1