topic Re: Multiple Parameter Values In Variable in QlikView

Multiple Parameter Values In Variable

redonkawa — Mon, 26 Jan 2026 21:26:37 GMT

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?

Re: Multiple Parameter Values In Variable

kaushiknsolanki — Fri, 26 Aug 2022 16:54:31 GMT

Yes it is possible.

Check out a great article by @shilpan.

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

Re: Multiple Parameter Values In Variable

rwunderlich — Fri, 26 Aug 2022 17:56:36 GMT

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