How to get dynamic Venn Diagram in Qlikview

[#1]

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

[Anonymous · Accepted solution]

See example attached.

[#3]

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

[Anonymous]

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

[#5]

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} Site)  gives the value 0 though the count must be 1. any idea why this is happening?

[Anonymous]

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!

[Anonymous]

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...

[Anonymous]

I appreciate that you replied!