Create a list of values variable for the usage in a SQL Where IN-Clause.

QlikView_List_of_Values_Variable.qvs

Companies:
LOAD * INLINE [
    Company
    CompanyA
    CompanyB
    CompanyC
];

List:
LOAD
  concat(Company,chr(39)&','&chr(39)) as AllCompanies
  resident Companies;

LET vList = chr(39)& peek('AllCompanies') & chr(39);

// Sample SQL Select Statement:
SQL SELECT * FROM company WHERE name IN ($(vList));

Alternative to peek:
LET vList = FieldValue('AllCompanies', 1);

Thanks!

Well, FieldValue() shouldn't be faster or better in this case of one row..