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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Venn Diagram

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)

14 Replies
Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
devarasu07
Master II
Master II

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)

Anonymous
Not applicable
Author

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.

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

devarasu07
Master II
Master II

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

Anonymous
Not applicable
Author

Script:

Venn_Diagram:

LOAD Person,

     English,

     Hindi,

     Jermen

FROM

(ooxml, embedded labels, table is Sheet1);

devarasu07
Master II
Master II

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

Anonymous
Not applicable
Author

PFA,