Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a simple Venn Diagram

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

2 Replies
danielrozental
Master II
Master II

Try this sample, it uses Google Charts.

Not applicable
Author

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.

Channel_Usage.PNG

The above image shows the chart obtained.

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

Thanks & Regards,

Aaspruha