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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
tresB
Champion III
Champion III

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