Hi
i have a list of Customers which they can be part of 4 group
may the can be part of group A or
A and B or
A and B and C or
C or B or D or
D and A and B.
Customer | Group A | Group B | Group C | Group D |
1111 | 1 | 0 | 1 | 1 |
2222 | 0 | 0 | 0 | 1 |
3333 | 1 | 1 | 1 | 1 |
4444 | 1 | 1 | 0 | 0 |
5555 | 0 | 0 | 0 | 1 |
6666 | 1 | 1 | 1 | 0 |
777 | 1 | 0 | 0 | 1 |
here "1" means that customer is part of that group
now i want to show this 4 different group with 4 circles same as attached pictures which each circle represents one group
and those shared area are for those costumers which they have shared group.
please help me to find a solution in Qlik to show this graphically.
Thanks