How to create a 2D table of pairs

tidus211 — Fri, 21 Jun 2019 18:13:06 GMT

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:

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

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 🙂

topic How to create a 2D table of pairs in App Development