Count names in column, but only count them once

[YannikPrill]

Hey QLIK Brains,

I think the title says it all... I Need to Count supplier names in a specific column, lets call it column [X]. Now each supplier is listed multiple times, but I just want to Count each one once. Is there a formula that does that? 

Thx in advance,

yannik

[simonaubert · Accepted solution]

Hello,

You can specifiy "distinct" such as :
count(distinct ID_Supplier)

[YannikPrill]

Thx 🙂 that worked!