How to pass multiple values in a variable

[ashis]

Hi,

Can you please help how to pass string values in a variable so that it can be used in an expressions.

I am trying to do this but it is not working;

vVar= {'Energy Syst*','Machine Learning'}

then I just need to pass this in an expression

sum({<usedby-={'Energy Syst*','Machine Learning'}>} sales)) ----> instead of 

sum({<usedby-= $(vVar)>} sales))

[vinieme12 · Accepted solution]

Like Below

vVar

'Energy Syst*','Machine Learning'         <<----Do not add = in variable definition

sum({<usedby-= {$(vVar)}>} sales)  <<{ } are  needed 

[Vegar · Accepted solution]

You can create the variable as you suggest, but your syntax is wrong.

Create your variable like this (notice the double "quotes":

SET vVar= {"Energy Syst*",'Machine Learning'}

When using wildchars in a set modifier you need to user double qoutes.

Then the expression can look like this :

=sum({<usedby-= $(vVar)>} sales)