Discussion board where members can get started with QlikView.
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.
May be like this
Count(TOTAL <VendorCode, ItemName> ID)
View solution in original post
Why 1, 1 for Item code of PD-6252-300 ?? I am assuming, It would be 2, 2
Count(TOTAL <ItemName> ItemName)
It is 1,1 because the VendorCode is different.
I want to count the amount of times each unique combination VednorCode and ItemName appears.
After that, I came to know
Count(TOTAL <VendorCode,ItemName> ItemName)
Many thanks Sunny and Anil