quick question
I have a table which is structured something like this:
customer_name, salesperson
customer1, person1
customer2, person1
customer3, person2
customer4, person2
customer3, person3
now I wish to make matrix in qlikview which will calculate how many distinct salespeople did sales to particular customer vs another customer
basically I should have a chart where both axis will have customer as a dimension, but the content of the box should be a number of overlaping persons
is there some easy to find solution to this?
Edit/update:
What I need is the matrix which will show how many unique salespeople is shared between combination of two customers.
so, in the example above customer 1 and customer 2 share same salesperson
customer 3, have two salespeople but only one is shared (with customer 4)
customer 4 have only one salesperson which is shared with customer 3
so my matrix should end up like this
| Header 1 | customer1 | customer2 | customer3 | customer4 |
|---|
| customer1 | 1 | 1 | 0 | 0 |
| customer2 | 1 | 1 | 0 | 0 |
| customer3 | 0 | 0 | 2 | 1 |
| customer4 | 0 | 0 | 1 | 1 |
