Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to get dynamic Venn Diagram in Qlikview

Hi All,

  I saw Venn Diagram for overlapping data in 'Whats new in Qlikview 11 '.  Can anyone guide me to build this kind of view?? Attached is the snapshot of the view.

Thanks

Abhishek

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: How to get dynamic Venn Diagram in Qlikview

See example attached.

7 Replies
mov
Esteemed Contributor III

Re: How to get dynamic Venn Diagram in Qlikview

See example attached.

Not applicable

Re: How to get dynamic Venn Diagram in Qlikview

Great!! Please guide me how I can learn using Google Developer with Qlikview.

mov
Esteemed Contributor III

Re: How to get dynamic Venn Diagram in Qlikview

I'm far for being an expert in that.  Just looked up Google API, and tried...

Highlighted
Not applicable

Re: How to get dynamic Venn Diagram in Qlikview

hi, i have tried the same method to get venn diagram. however the intersection of two states is not giving me the right value.

State 1 gives resultant sites 1,2,3,4,5,6. Thus, count=6

State 2 gives site 1. Thus, count=1.

count({State1*State2} Sitegives the value 0 though the count must be 1. any idea why this is happening?


qlikrajan
Contributor III

Re: How to get dynamic Venn Diagram in Qlikview

Hey Michael:

I am trying to create a venn diagram and your post was very helpful in this regard. I have a question. When I create a condition in which customer 1 and customer 2 have common things, customer 2 and customer 3 have common things and customer 3 and customer 1 have common things but there is nothing in common among all three customers, then I find the chart still gives intersection for three customers but actually  that area should be 0. I have selected the values in attached qvd. Could you please have a look and share your view.

Thanks!

mov
Esteemed Contributor III

Re: How to get dynamic Venn Diagram in Qlikview

I understand what you mean but cannot help here.  Not quite sure how it should look in this case.  If overlapping areas between sets are large enough, the 3-way intersection is unavoidable - but it doesn't represent actual selections.

Anyway, this is what we get from Google.  I'll be happy to hear an explanation too...

qlikrajan
Contributor III

Re: How to get dynamic Venn Diagram in Qlikview

I appreciate that you replied!

Community Browser