How to use set modifier with a variable ?

Derek_T — Mon, 11 Jul 2022 20:17:10 GMT

Let's say I have a formula like the one below (taken from Qlik help):

sum( {$<Year = {2000}, Region = {US, SE, DE, UK, FR}>} Sales )

Instead of listing the countries: {US, SE, DE, UK, FR} I'd like to find a way to dynamically compute this list based on value available in one of the table.

The table would look something like this:

Country / Value 1 / Value 2 ...
US
US
FR
FR
FR
DE
US
UK
...

I'd like to be able to extract the list of unique countries from this table and pas it as an argument to the set modifiers.

Thanks !

Re: How to use set modifier with a variable ?

stevejoyce — Mon, 11 Jul 2022 20:24:10 GMT

you can look to use the P() function here.

Region = P({< optional set analysis to determine which countries >} Country)

topic Re: How to use set modifier with a variable ? in App Development

How to use set modifier with a variable ?

Re: How to use set modifier with a variable ?