Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

"Count" with "In" clause

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])

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: "Count" with "In" clause

Hi

Try like this

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

 

Hope this helps

thanks

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: "Count" with "In" clause

Hi

Try like this

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

 

Hope this helps

thanks

View solution in original post