Set analysis - formula help for multiple selections

Mon, 01 Oct 2012 09:39:08 GMT

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

Re: Set analysis - formula help for multiple selections

jagan — Mon, 01 Oct 2012 09:50:24 GMT

Hi,

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

Regards,

Jagan.

Re: Set analysis - formula help for multiple selections

Mon, 01 Oct 2012 10:02:16 GMT

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

topic Re: Set analysis - formula help for multiple selections in QlikView

Set analysis - formula help for multiple selections

Re: Set analysis - formula help for multiple selections

Re: Set analysis - formula help for multiple selections