topic Re: Inject Variable into Set analyis in Featured Members

Inject Variable into Set analyis

GrantSk — Mon, 06 Feb 2023 10:58:45 GMT

Hi all,

I'm trying to inject a variable into a Master Item depending on selections.

Ideally if no selection is made then the Master Item would be something like:

Sum({< Product = {'Shoes'} >} Sales)

But should a certain selection is made then ideally the Master Item would look like:

Sum({< Product = {'Shoes'} & '$(vVar)' >} Sales)

The variable would look like :

vVar = ' ,Country = {'England'}'

This is wanted to avoid creating a number of master items which are identical except for one filter difference. So when nothing is selection the vVar would be null.

Re: Inject Variable into Set analyis

marcus_sommer — Mon, 06 Feb 2023 11:55:01 GMT

You may apply:

vVar: = if(getselectedcount(YourField), ' ,Country = {'England'}', '');

Sum({< Product = {'Shoes'} & $(vVar) >} Sales)

Re: Inject Variable into Set analyis

GrantSk — Mon, 06 Feb 2023 15:44:17 GMT

@marcus thanks for your reply. This got me most of the way there . In the master item I had to remove the & for it to work:

Sum({< Product = {'Shoes'} $(vVar) >} Sales)

The variable I had to add Chr(39) to get the ' to show:

vVar = If(getselectedcount(YourField),',Country = {' & chr(39) & 'England' & chr(39) & '}', '')