Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel1908
Creator
Creator

Count Material with equal Text in the same column

Hello Together, 

I want to count only the Material Numbers which got the same Description Text in the same column. 

Any Ideas how to create the formula?

Kind Regards,
Daniel

2 Replies
tresesco
MVP
MVP

Example?

Daniel1908
Creator
Creator
Author

In the below case I only want to count Srews and Pliers because they have more than one entry for the description. 
I do not want to count the Material Number which have the description once. 

Daniel1908_0-1618831205589.png