Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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