Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Venn Diagram chart

Hi Guys,

This is first time i'm working on extension objects, I have a requirement where i have to create Venn diagram chart in Qlikview. Please share me your ideas on it. This Venn Diagram chart should worked for N series of circles(Dynamic Chart)

12 Replies
ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, Dee.

QlikView doesn't have Venn Diagrams.

However, you can look for Google API extension which you can pull in. (just search for google api venn diagram). The downside of this though is that it relies on Google supporting this. As it gets pulled in as an image you don't have the full range of QlikView functionality you would expect from a chart.

Regards,

Neil.

Siva_Sankar
Master II
Master II

Try using google API. Refer this document Venn Diagram in Qlikview using google chart api

sunny_talwar

Google API will be the way to go, but the only pitfall here is that it allows for only three circles. Not sure I if there is anything else that would allow for N circles, but I would be curious to know if there is something out there.

Best,

Sunny

ankit777
Specialist
Specialist

MarcoWedel

Hi,

I guess it should be possible without extensions or external plot apis to create a Venn diagram using a scatter chart and some expressions to calculate bubble positions and sizes.

QlikCommunity_Thread_158371_Pic1.JPG

hope this helps

regards

Marco

sunny_talwar

Wow, this looks much better than Google Api's version of the Venn Diagram. I am amazed how this method has never been mentioned on the community before.

Thanks for sharing this Marco Wedel

Best,

Sunny

Not applicable
Author

Hi Marco,

Do you have expressions to calculate bubble positions, in case we have buble sizes and also we know the intersection rates for bubbles? For example, let's say

B1 = 100, B2 = 80, B3 = 20, B1B2 = 80, B1B3 = 20, B2B3 = 20 and B1B2B3 = 20


Thanks,

anilmahanty
Contributor III
Contributor III

Is there way, we can so the value as well for each area of the Vann diagram?

Anonymous
Not applicable
Author

Hi,

I also want  to implement the Vann diagram i qlikview . So I followed your answers and these guides:

How can I create Venn Diagram in Qlikview? - tools - Data Science, Analytics and Big Data discussion...

Venn Diagram in Qlikview using google chart api

Somehow, this is what i get finally:

problem.JPG

I assume the problem  is in my expression. but I don't know where :

='http://chart.apis.google.com/chart?cht=v&chs=330x220&chdl=SAS - '&$(vS)&'|R - '&$(vR)&'|Python - '&$(vP)&'&&chco=8DAACB,FC7362,BBD854&chd=t:'

&$(vS)&','&$(vR)&','&$(vP)&','&$(vSR)&','&$(vSP)&','&$(vRP)&','&$(vSRP)

Thanks for any help:)