Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Count amount of duplications/COUNTIFS for column

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:

  • ID, VednorCode, ItemName is the raw data.
  • Duplications is what I am trying to get (In Yellow)

  

IDVendorCodeItemNameDuplications
1H9004280062513
2H9004280062513
3H9004280062513
4H90042800PD-6251-3002
5H90042800PD-6251-3002
6H90042800PD-6252-3001
7H03000773PD-6252-3001
8H03000773PD-6011-3003
9H03000773PD-6011-3003
10H03000773PD-6011-300

3

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?

1 Solution

Accepted Solutions
Highlighted

Re: Count amount of duplications/COUNTIFS for column

May be like this

Count(TOTAL <VendorCode, ItemName> ID)

View solution in original post

6 Replies
Highlighted

Re: Count amount of duplications/COUNTIFS for column

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

Count(TOTAL <ItemName> ItemName)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Re: Count amount of duplications/COUNTIFS for column

May be like this

Count(TOTAL <VendorCode, ItemName> ID)

View solution in original post

Highlighted
Creator
Creator

Re: Count amount of duplications/COUNTIFS for column

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.

Highlighted

Re: Count amount of duplications/COUNTIFS for column

Sample attached

Capture.PNG

Highlighted

Re: Count amount of duplications/COUNTIFS for column

After that, I came to know

Count(TOTAL <VendorCode,ItemName> ItemName)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator
Creator

Re: Count amount of duplications/COUNTIFS for column

Many thanks Sunny and Anil