Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Counting unique values based off another field

In the example attached, I'm trying to count when a "part" has more than one  unique "ID" associated.  So my end results should say:

A  - 2 ( because it has 1 & 5 associated)

B  - 1 (because both IDs are "2"

C - 1 (because both IDs are "3"

It would also be helpful to see what IDs are associated when there is more than 1, but this isnt necessary.

Thank you!

Labels (2)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Hi, Create a table box with Part as dimension and Count(Distinct ID) as Expression(Measure) Hope this helps.
Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Hi, Create a table box with Part as dimension and Count(Distinct ID) as Expression(Measure) Hope this helps.
Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post