topic Re: Matrix showing combinations in QlikView

Matrix showing combinations

Thu, 09 Jan 2014 16:39:58 GMT

I have a little puzzle.
I have a table with user and group connections as shown here

Group	User
10	A
10	B
10	C
11	A
11	C
12	B
13	A
13	B

I need to produce a matrix showing the number of user that has connections to the different combinations groups as
shown here

	10	11	12	13
10	3	2	1	2
11	2	2	0	1
12	1	0	1	1
13	2	1	1	2

I recognize that I might have to generate a table like this

Group	Group2	User
10	10	A
10	10	B
10	10	C
10	11	A
10	11	C
10	12	B
10	13	A
10	13	B

(just for the first column)

On the basis of the first table, but how to do it?

Re: Matrix showing combinations

Nicole-Smith — Thu, 09 Jan 2014 20:53:50 GMT

How about the attached?

Re: Matrix showing combinations

Fri, 10 Jan 2014 07:29:21 GMT

Thanks it was exactly
what I were looking for, my problem was that I was building on the existing
table and there creating problems in the other graphs, but using this and
creating a new table made it work.