Visualizing Overlaps between Customer Groups

[bernd_schuetze]

Hi,

does anyone have a good idea how to automatically visualize overlaps between customer groups?

Example: Customers purchasing fruits

14 (all three)	Banana	Orange	Apple
Banana	10 (only banana)	20 (banana and orange)	12 (banana and apple)
Orange	20 (banana and orange)	16 (only Orange)	104 (apple and orange)
Apple	12 (banana and apple)	104 (apple and orange)	5 (only apple)

I would like to show the overlaps visually comprehensive. On a whiteboard I would do something like

But this does have the issue that if the overlaps (e.g. A+O) are bigger then A, this is not presented visually appropriate.

I can of course hardcode it into the page, and make the size of the Font dependent on the amount, but this seems so futile...

Anyone who did something like this in a more automated fashion?

Especially interesting would be to learn how to accommodate 5 Groups visually.

Thanks!

Bernd

[Gysbert_Wassenaar · Accepted solution]

Perhaps this helps: How to get dynamic Venn Diagram in Qlikview