QlikView App Dev

Report Inappropriate Content · ‎2012-04-25

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

CELAMBARASAN · ‎2012-04-25

Hi,

Check with it

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

Celambarasan

jonathandienst · ‎2012-04-25

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

String Literals in the script