Creating a simple Venn Diagram

Mon, 21 Jan 2013 04:48:58 GMT

Hi,

I need to a create a venn diagram. I have a column as 'Channel_Usage', I need to find the count for each channel used using the column 'Channel_Usage'. I am unable to do so. Any help regarding this will be highly appreciated.

Thanks in advance.

Regards,

Aaspruha

Re: Creating a simple Venn Diagram

danielrozental — Mon, 21 Jan 2013 12:20:24 GMT

Try this sample, it uses Google Charts.

Re: Creating a simple Venn Diagram

Tue, 12 Feb 2013 12:03:50 GMT

Hi Daniel,

Thanks for the reply.

But I still face some issues.

Details provided:

I have a field as 'channel_name' in my file where 3 values are present : 'ATM', 'POS', 'TELLER'

Here ‘ATM’ has been defined as Set1, ‘POS’ as Set2 and ‘TELLER’ as Set3 (Set1, Set2 & Set3 are the bookmarks defined).

‘x_field’ is a field defined manually using the below script:

LOAD * INLINE
[
channel_name, x_field
ATM,1
TELLER,2
POS,3
];

In the ‘Expressions’ tab:

='http://chart.apis.google.com/chart?cht=v&chs=330x220&'&

'chdl=Set1|Set2|Set3&'&

'&chco=8DAACB,FC7362,BBD854&'&

'chd=t:'&

sum({Set1}x_field)&','&

sum({Set2}x_field)&','&

sum({Set3}x_field)&','&

sum({Set1*Set2}x_field)&','&

sum({Set1*Set3}x_field)&','&

sum({Set2*Set3}x_field)&','&

sum({Set1*Set2*Set3}x_field) has been mentioned.

The above image shows the chart obtained.

Can you suggest the steps to be implemented to get the correct venn diagram?

Thanks & Regards,

Aaspruha

topic Creating a simple Venn Diagram in QlikView

Creating a simple Venn Diagram

Re: Creating a simple Venn Diagram

Re: Creating a simple Venn Diagram