topic How to get Duplicate values Summary.. as Below in QlikView

How to get Duplicate values Summary.. as Below

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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......

Re: How to get Duplicate values Summary.. as Below

settu_periasamy — Tue, 06 Mar 2018 05:24:08 GMT

Hi,

Just Load your excel file into QV.

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

I think you will get the desired result.

Re: How to get Duplicate values Summary.. as Below

prma7799 — Tue, 06 Mar 2018 05:28:42 GMT

Like this

Re: How to get Duplicate values Summary.. as Below

Anonymous — Tue, 06 Mar 2018 05:31:25 GMT

Thanks for Reply..

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

Regards,

Rafee

Re: How to get Duplicate values Summary.. as Below

settu_periasamy — Tue, 06 Mar 2018 05:48:49 GMT

Try this.

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

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

Re: How to get Duplicate values Summary.. as Below

shiveshsingh — Tue, 06 Mar 2018 05:51:33 GMT

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

Re: How to get Duplicate values Summary.. as Below

dinuwanbr — Tue, 06 Mar 2018 05:55:23 GMT

Hi,

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

Rgds,

Dinu1