String variable in match function in expression

[linoyel]

Hi, I have a variable vRelevantBusinesses returning me a list of string values of a field "Business":

vRelevantBusinesses_temp: Concat(distinct Business,',')

vRelevantBusinesses: Chr(39) & Replace($(vRelevantBusinesses), ',', Chr(39) & ',' & Chr(39)) & Chr(39)

The vRelevantBusinesses variable output is 'a','b','c'

I need to write set analysis using match function and the vRelevantBusinesses variable output but it doesn't work:

=If(match(Business, $(vRelevantBusinesses)), Business)

Without the variable it works:

=If(match(Business, 'a','b','c), Business)

Please help on getting this to work: =If(match(Business, $(vRelevantBusinesses)), Business)

Sample app is attached.

Thanks!

[pradosh_thakur]

try this

=If(match(Business, $(=vRelevantBusinesses)), Business)

[linoyel]

Thanks, but no, that doesn't work either.

[pradosh_thakur]

try

chr(39) & concat(distinct Business,chr(39)&','&chr(39)) & chr(39) as varibale

[linoyel]

Your variable is great and it returns the same output which is 'a','b','c'

The problem is when using this variable in match function

[pradosh_thakur]

which object are you using this expression? if possible post a sample.

[linoyel]

Bar chart

[pradosh_thakur]

please post a sample. working for me when i am trying in my app.

[linoyel]

I've attached the sample to the initial posting, thanks

[sunny_talwar]

Try this

=If(match(Business, $(=$(vRelevantBusinesses))), Business)