Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (2)
2 Replies

String Literals in the script

Hi,    

     Check with it

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

Celambarasan

MVP
MVP

Re: String Literals in the script

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
Community Browser