"Count" with "In" clause

[fortaleza40]

Hello Comunity,

I am working in a expression where i must use the "Count" clause with "In" clause, i have a group id (Customer Group) to grouping all my costumers and a Customer Unique ID, i just need to count the costumer in a Customer Group, i have the formula but not sure how to do the same in Qlik, i check the documentation for Count and the forum but i didn't found an answer so i am posting this new question.

This is what i want to do:

Count([Customer Unique Id]) In ([Customer Group])

[Kashyap_R · Accepted solution]

Hi

Try like this

Count(Distinct{<CustomerGroup = {'GroupID or Name'}>} CustomerID)

Hope this helps

thanks