Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Hi
Try like this
Count(Distinct{<CustomerGroup = {'GroupID or Name'}>} CustomerID)
Hope this helps
thanks
Hi
Try like this
Count(Distinct{<CustomerGroup = {'GroupID or Name'}>} CustomerID)
Hope this helps
thanks