Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
its_rajvir
Creator
Creator

Passing multiple values in a variable

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,

Labels (6)
5 Replies
salonicdk28
Creator II
Creator II

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
Creator
Creator
Author

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

Oliver_F
Partner - Creator III
Partner - Creator III

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

its_rajvir
Creator
Creator
Author

@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
Partner - Creator III
Partner - Creator III

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))