Set Analysis Selection

[Anonymous]

I know how to use Set Analysis in chart expressions, but how do you use Set Analysis to make selections using a Button Object Action (e.g., Select in Field)?

[tresesco]

Set analysis is used in aggregation functions and to trigger a selection you have to pass a string (Search String) that you can do like :

=Chr(39)&'('& Concat({1} DISTINCT Year, '|') &')'&chr(39)

Here i have taken Year's(a field) all values to be selected irrespective of the existing selection.

i. e, you have to use aggregation functions(Concat, Only ...) i believe.

[Anonymous]

Thanks. It pointed me in the right direction, I wound up using:

=if($(vLimitSales)<>1,'(' & concat({$< Component = {"=aggr(sum(Sales_Value),Component) <$(#=vMaxSales*1000)"}>} Component, '|') & ')')

Just out of curiosity, what's the purpose of bracketing the expression with the ASCII single quotes, Chr(39)? I didn't need them.