How to create a 2D table of pairs

[tidus211]

Hello,

I'm quite new to Qlik Sense and I try to create in my dashboard something like a 2D table of pairs. An exemple will be easier:

Computer ID	Employee
ID_1	Bob
ID_1	Paul
ID_1	Zoe
ID_2	Bob
ID_2	Bob
ID_2	Paul
ID_2	Zoe
ID_3	Zoe
ID_4	Paul
ID_4	Zoe
ID_5	Bob
ID_5	Zoe

From this table, I would like to have a heatmap or something similar to reproduce this :

	Bob	Paul	Zoe
Bob	1	2	3
Paul	2	0	3
Zoe	3	3	0

For Bob-Bob, I count how many computers ID have (at least) 2 Bob users (ID_2 here).

For Zoe-Bob (or Bob-Zoe, it's symmetric) I have them on ID_1 / ID_2 / ID_5

For Paul-Bob, it's on ID_1 / ID_2.

Do you have a solution in order to achieve this result ?

Thank you 🙂