Passing multiple values in a variable

[its_rajvir]

Dear Experts,

I am trying to find a solution for one problem, i searched in previously asked questions also but no solution worked.

It may be easy, I want to pass multiple values in a variable. For instance something like this :

Let CustomerID = ('012306', '567835', '722653', '527394')

Please Help!

Thanks and Regards,

[salonicdk28]

Refer the below link if it is useful for you-

https://community.qlik.com/t5/New-to-Qlik-Sense/Passing-multiple-parameter-values-through-a-variable...

or you can use-

chr(39)&'012306'&chr(39)&','&chr(39)&'567835'&chr(39) so on like this 

Thanks,

Saloni

[its_rajvir]

dear @salonicdk28 Thank you for the reply, but i tried this solution its not working for me. 😑

[Oliver_F]

How/Where do you use that "list"-Variable?

[its_rajvir]

@Oliver_F  i am trying to create a variable outside the load script and calling it while loading the data.

For example something like this:

 Let vCustomerId = ('123456', '123455', '423452');

[Table 1] :

load * 

from the file

where the customerID = $(vCustomerId)

[Table 2] :

load * 

from the file

where the customerID = $(vCustomerId)

[Table 3] :

load * 

from the file

where the customerID = $(vCustomerId)

[Oliver_F]

Hi,

the variable will contain *one* value. Still this *one* value can be interpretated as a list.

You will have to use an expression that can handle lists.

Try this where-statement: where match(CustomerID,$(yourVariable))