topic Re: Venn Diagram in QlikView

Venn Diagram

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello ,

I tried below expression but it gives error "Garbage After Expression '|Hindi-' "

='http://chart.apis.google.com/chart?cht=v&chs=330x220&chdl=English -'&$(vE)&'|Hindi - '&$(vH)&'|Jermen '-' '&$(vJ)&'&&chco=8DAACB,FC7362,BBD854&chd=t:'

&$(vE)&','&$(vH)&','&$(vJ)&','&$(vEH)&','&$(vEJ)&','&$(vHJ)&','&$(vEHJ)

Re: Venn Diagram

Anil_Babu_Samineni — Wed, 27 Dec 2017 07:10:10 GMT

Can you work with 2 single Quotes here

='http://chart.apis.google.com/chart?cht=v&chs=330x220&chdl=English -'&$(vE)&'|Hindi - '&$(vH)&'|Jermen ''-'' '&$(vJ)&'&&chco=8DAACB,FC7362,BBD854&chd=t:'&$(vE)&','&$(vH)&','&$(vJ)&','&$(vEH)&','&$(vEJ)&','&$(vHJ)&','&$(vEHJ)

Re: Venn Diagram

devarasu07 — Wed, 27 Dec 2017 07:11:24 GMT

Hi,

try this. u have extra single code for '-'

='http://chart.apis.google.com/chart?cht=v&chs=330x220&chdl=English - '&$(vE)&'|Hindi - '&$(vH)&'|Jermen - '&$(vJ)&'&&chco=8DAACB,FC7362,BBD854&chd=t:'

&$(vE)&','&$(vH)&','&$(vJ)&','&$(vEH)&','&$(vEJ)&','&$(vHJ)&','&$(vEHJ)

Re: Venn Diagram

Anonymous — Wed, 27 Dec 2017 07:14:02 GMT

this one is original exp:

='http://chart.apis.google.com/chart?cht=v&chs=330x220&chdl=English - '&$(vE)&'|Hindi - '&$(vH)&'|Jermen - '&$(vJ)&'&&chco=8DAACB,FC7362,BBD854&chd=t:'

&$(vE)&','&$(vH)&','&$(vJ)&','&$(vEH)&','&$(vEJ)&','&$(vHJ)&','&$(vEHJ)

but still same issue.

Re: Venn Diagram

Anil_Babu_Samineni — Wed, 27 Dec 2017 07:17:16 GMT

There is no issue in expression? What you want to see with that link? It will show only static name for all with in single quote but for variable it will show dynamic..

Re: Venn Diagram

Anonymous — Wed, 27 Dec 2017 07:30:19 GMT

Please Check

https://community.qlik.com/docs/DOC-5262

Re: Venn Diagram

devarasu07 — Wed, 27 Dec 2017 07:46:49 GMT

Hi,

The original expression no issue. any other configuration/expression issue apart from this chart expression?

would be better if you clearly explain your issue with screen. Tks

Re: Venn Diagram

Anonymous — Wed, 27 Dec 2017 07:51:20 GMT

Script:

Venn_Diagram:

LOAD Person,

English,

Hindi,

Jermen

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Venn Diagram

devarasu07 — Wed, 27 Dec 2017 08:13:19 GMT

Hi,

are u getting this front end chart issue while create text box or straight table?

would be able to share the app which is having the issue in your above screen shot

Re: Venn Diagram

Anonymous — Wed, 27 Dec 2017 08:17:54 GMT

PFA,

Re: Venn Diagram

devarasu07 — Wed, 27 Dec 2017 08:43:40 GMT

Hi,

the issue is because of there is front empty space in your variable expression.after removing it should be ok.

Re: Venn Diagram

Anonymous — Wed, 27 Dec 2017 08:48:28 GMT

not getting you..

Re: Venn Diagram

devarasu07 — Wed, 27 Dec 2017 08:52:26 GMT

Hi,

while you re-create all the chart expression there is space in front for variable name and it's not reflected in the chart expression refer to the attachment.

refer below screen (variable name with front space be remember that qlik is a case sensitive tool.)

Re: Venn Diagram

Anonymous — Wed, 27 Dec 2017 09:00:03 GMT

i am unable to open qvw, if possible please share text file

Re: Venn Diagram

devarasu07 — Wed, 27 Dec 2017 09:09:07 GMT

Hi,

okay, try to remove all your existing expression and re-create below list

Count({<English={'Y'}>}Person)

Count({<Hindi={'Y'}>}Person)

Count({<Jermen={'Y'}>}Person)

vEH

Count({<Hindi={'Y'},English={'Y'}>}Person)

vEJ

Count({<Jermen={'Y'},English={'Y'}>}Person)

vHJ

Count({<Hindi={'Y'},Jermen={'Y'}>}Person)

vEHJ

Count({<Hindi={'Y'},English={'Y'},Jermen={'Y'}>}Person)