Multiple Parameter Values In Variable

[redonkawa]

I'm trying to use multiple values for a parameter within a variable, and would like to know firstly if this is possible, and secondly how to do it.

I have variable v.Example (obviously I am using proxies as I can't show my details)

Sum({< Category1 = {"$1"},
              Category2 = {"$2"}>}
Amount)/1000))

Category1 can take the following values up, down, left, right

Category2 can take the following values peppermint, topspin, Cthulu - 

So if I'm looking for say Category1 to be down, and Category2 to be Cthulu, I would now write

$(v.Example(down, Cthulu))

I would like to be able to select more than one value for each parameter, so I would like to use something similar to the below.

$(v.Example(down, [peppermint, Cthulu]))

Can someone please help out with the correct syntax?

[kaushiknsolanki]

Yes it is possible.

Check out a great article by @shilpan.

https://analyticshub.io/2020/05/02/nested-parameterized-variables/

[rwunderlich]

The parameter values themselves cannot contain commas. The only workaround I know is to use a proxy character for comma and then replace in the function. Like:

$(v.Example(down, [peppermint|Cthulu]))

And your function would be:

Sum({< Category1 = {"$1"},
              Category2 = {"replace('$2', '|', ',')'"}>}
Amount)/1000))

-Rob