Counting values from a column if that row is a distinct entry in a different column

[Qlik-Learner-24]

Hello all,

I am wondering how I can count the number of entries for a value from one column (‘Manufacturer’) for entries that are distinct values in another column (Product ID).

Manufacturer	Product ID	Batch
Jane Co.	2514	1
Jane Co.	5812	1
Jane Co.	5812	2
Smith Co.	1582	1
John Co.	1741	1

So for this example, I don’t care that I have two batches of 5812 from Jane Co, but I do want to know how many distinct products we stock produced by each manufacturer so I can make some graphical representations such as a pie chart showing manufacturer product distribution.  

I’m sure this question has been asked before, but I’m very new to Qlik, and I don’t think I’m using the right search terms to find the answer. Thank you for any help you can give.

[Kushal_Chawda · Accepted solution]

@Qlik-Learner-24  If I understood it correctly, Count(distinct ProductID) expression will be sufficient in pie chart to show distribution

[Qlik-Learner-24]

Hi Kushal,

Thank you for your help. For whatever reason, my brain was insisting that Dimensions (slices) and Measures (slice angle) had to refer to the same variable, so the 'Manufacturer' column was kinda-okay to use the count of except for of course it does not handle duplicate product IDs! 

I appreciate you taking the time to respond to my post.