Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Partner

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?

omerl2322
Contributor
Contributor

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:)