Count total group by customer

[tanphat911]

Hello All,

I am new to Qlik , Hope you can support me to this scenario.

I have table Customer & Group.

For Example:

Customer A - Group 1

Customer A - Group 2

Customer A - Group 3

Customer B - Group 1

Customer C - Group 2

I would like to have output to visual on chart

Total Customer Belong to 3 group : 1

Total Customer Belong to 1 group : 2

I have write some script like 

sum( Aggr(count(distinct(group)),customer))

Customer A, 3

Customer b,1

Customer c,1

But i don't know how to do next for other count

[abhijitnalekar]

Hi @tanphat911 ,

Have you tried 

sum( Aggr(count(distinct(customer)),group)).

[tanphat911]

Hi @abhijitnalekar ,

Total Customer Belong to 3 group : 1

Total Customer Belong to 1 group : 2

So for get Dimension Total Customer Belong to 3 group  .

How  I can get this ?

[tanphat911]

nvm, I found solution 😄

I will create a new dimension calculated by

=if(Aggr(count(distinct(bu)),cust_key) >= 3,'>=3'
,if(Aggr(count(distinct(bu)),cust_key)= 2,'2'
,if(Aggr(count(distinct(bu)),cust_key)= 1,'1',0)))