topic Re: String Literals in the script in QlikView

String Literals in the script

Wed, 25 Apr 2012 16:56:09 GMT

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 — Wed, 25 Apr 2012 18:35:31 GMT

Hi,

Check with it

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

Celambarasan

jonathandienst — Wed, 25 Apr 2012 20:00:38 GMT

Siri

You can just di this:

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

Regards

Jonathan