creating relation/cartesian matrix

marko_rakar — Wed, 17 Jun 2015 10:59:14 GMT

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

Re: creating relatiin/cartesian matrix

jonas_rezende — Wed, 17 Jun 2015 14:27:30 GMT

Hi, Marko Rakar.

See if the example attached help.

Make load after download. I reduced the size to upload.

topic creating relation/cartesian matrix in QlikView

creating relation/cartesian matrix

Re: creating relatiin/cartesian matrix