Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
nongspits
Contributor
Contributor

Multiple Parameter Values In Variable

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

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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 

marcus_sommer

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