topic Re: Count amount of duplications/COUNTIFS for column in QlikView

Count amount of duplications/COUNTIFS for column

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

Hello All,

I am trying to find amount of duplications within a database, based on certain columns.

Below is a sample of the data I have:

Duplications should show the total amount of times each combination of VednorCode and ItemName appears.

Duplications amount in each line refers to VendorCode and ItemName in the same line.

Basically, it is the same as if I would use COUNTIFS(B:B,$B2,C:C,$C2) in excel.

Any ideas?

Anil_Babu_Samineni — Thu, 25 May 2017 17:41:11 GMT

Why 1, 1 for Item code of PD-6252-300 ?? I am assuming, It would be 2, 2

Count(TOTAL <ItemName> ItemName)

sunny_talwar — Thu, 25 May 2017 17:43:31 GMT

May be like this

Count(TOTAL <VendorCode, ItemName> ID)

yanivbm88 — Thu, 25 May 2017 17:44:35 GMT

Hi Anil,

It is 1,1 because the VendorCode is different.

I want to count the amount of times each unique combination VednorCode and ItemName appears.

sunny_talwar — Thu, 25 May 2017 17:46:04 GMT

Sample attached

Anil_Babu_Samineni — Thu, 25 May 2017 17:54:08 GMT

After that, I came to know

Count(TOTAL <VendorCode,ItemName> ItemName)

yanivbm88 — Thu, 25 May 2017 17:59:01 GMT

Many thanks Sunny and Anil