Set analysis - formula help for multiple selections

[#1]

Hi All,

I have a table that isn't linked to use for comparative selections in QV10.

Here is the formula that works in a text box:

=chr(39)&concat(  box_select_A,  chr(39) &  ',' & chr(39))&chr(39)

This results in a text box showing the single or multiple selections I have like so:

'A', 'B', 'C', 'D'

I try to put this into set analysis to allow for multiple selections:

sum(   {< box={ "$(=chr(39)&concat(   box_select_A,  chr(39) &  ',' & chr(39))&chr(39) )"  }>}    metricA)

I have also tried the following, changing the way the box_select_A is included:

 sum(   {< box={ "$(=chr(39)&concat(   $(box_select_A),  chr(39) &  ',' & chr(39))&chr(39) )"  }>}    metricA)
sum(   {< box={ "$(=chr(39)&concat(   '$(box_select_A)',  chr(39) &  ',' & chr(39))&chr(39) )"  }>}    metricA)
sum(   {< box={ "$(=chr(39)&concat(   $(=box_select_A),  chr(39) &  ',' & chr(39))&chr(39) )"  }>}    metricA)
sum(   {< box={ "$(=chr(39)&concat(   '$(=box_select_A)',  chr(39) &  ',' & chr(39))&chr(39) )"  }>}    metricA)

But no luck.  Has anyone achieved this?  I'm just trying to build a list in the set for box that looks like:

'A','B','C'  etc...

Thanks

Gareth

[jagan · Accepted solution]

Hi,

Please find attached file for solution.  Hope it helps you.

Regards,

Jagan.

[#3]

Great!  I hadn't thought of using a variable.  Thanks for that!