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 🙂