topic Re: Venn Diagram chart in QlikView

Venn Diagram chart

Tue, 31 Mar 2015 18:07:49 GMT

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)

Re: Venn Diagram chart

ngulliver — Mon, 08 Jun 2015 13:45:12 GMT

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.

Re: Venn Diagram chart

Siva_Sankar — Sat, 27 Jun 2015 11:00:26 GMT

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

Re: Venn Diagram chart

sunny_talwar — Sat, 27 Jun 2015 12:34:59 GMT

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

Re: Venn Diagram chart

ankit777 — Sat, 27 Jun 2015 17:57:21 GMT

Hi,

Check this link.

Venn Diagram in Qlikview using google chart api

Re: Venn Diagram chart

MarcoWedel — Sat, 27 Jun 2015 22:19:23 GMT

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.

hope this helps

regards

Marco

Re: Venn Diagram chart

sunny_talwar — Sun, 28 Jun 2015 02:31:32 GMT

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

Re: Venn Diagram chart

Thu, 02 Jun 2016 11:38:31 GMT

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,

Re: Venn Diagram chart

anilmahanty — Thu, 23 Jun 2016 09:59:22 GMT

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

Re: Venn Diagram chart

Anonymous — Sun, 02 Jul 2017 15:25:14 GMT

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 discussions

Venn Diagram in Qlikview using google chart api‌

Somehow, this is what i get finally:

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

Re: Venn Diagram chart

d_brown — Wed, 07 Feb 2018 12:25:07 GMT

The Google Venn Diagram has been deprecated by Google so it doesnt work anymore.

Re: Venn Diagram chart

Anonymous — Mon, 26 Feb 2018 23:35:50 GMT

Can we be sure deprecation by google of the venn diagram is the cause of the failure? Cut and paste of the api call (from QV text expression) directly into the browser still returns the diagram. Here is the call from my expression as an example:

http://chart.apis.google.com/chart?cht=v&chs=500x350&chco=556292,F1E3C5&chof=png&chdl=Experience|MA Research&chd=t:13.77,3.433,0,0.661

Re: Venn Diagram chart

d_brown — Tue, 27 Feb 2018 09:44:18 GMT

Hi Steve

No we cant be sure, but if it is deprecated then there likely wont be any support for it either. It says to use the Google Charts API but I couldn't see a Venn Chart in that list. Maybe someone else has managed to find one hidden somewhere. Maybe I have picked up the wrong API reference?

Regards

David