Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String Literals in the script

Hi Folks,

I need create the string like below and used this sting in my SQL query.

Let vValues = 'India','Usa','Aus';

My SQL: Select * from Customer where Country in ($(vValues ))

How can i do that in the script.

Thanks & Regards,

Siri

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,    

     Check with it

     Let vValues = chr(39)&'India'&chr(39)&','&chr(39)&'Usa'&chr(39)&','&chr(39)&'Aus'&chr(39);

Celambarasan

jonathandienst
Partner - Champion III
Partner - Champion III

Siri

You can just di this:

Set vValues = 'India','Usa','Aus';

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein