topic Re: Multiple Parameter Values In Variable in QlikView

Multiple Parameter Values In Variable

nongspits — Thu, 06 Jan 2022 16:27:14 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?

Cheers

Re: Multiple Parameter Values In Variable

rwunderlich — Thu, 06 Jan 2022 16:46:50 GMT

You can't use a comma within a variable value. It will always be interpreted a parameter separator. The only workaround I know is to use a proxy character like "peppermint| Cthulu" and then swap the "|" for "," in the variable using Replace(). The syntax can get pretty ugly.

-Rob

Re: Multiple Parameter Values In Variable

marcus_sommer — Thu, 06 Jan 2022 17:12:19 GMT

Like Rob mentioned you need to avoid commas within a single-parameter. But depending on your intended usage you may reach it also with a different expression-syntax. In your case you could list the multi-values like:

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

- Marcus