Data islands and set analysis

[#1]

I have two tables, one containing invoices and one with purchase orders, associated on the purchase order number, but sometimes that is null on the invoices table. Both have the company name which I want to filter on in both tables for separate sheet objects.

I don't want to associate the two company fields as it creates loops etc so I have created a data island doing a resident load on the two tables.

The three fields are currently [INV company], [PO Company] and [Island Company]

If I make a single selection on [Island Company] I can put it in a variable and use it in set analysis e.g. {$< [PO Company] = {"=$(vReportcompany)"}>}

The problem comes when I select more than one [Island Company]. How do I put that into set analysis?

Do I have to use if statements (and how do I do that for multiple selections?) or is there a way of doing it in set analysis?

[MK_QSL]

Can you provide sample apps?

[#3]

OK Manish, I will simplify the current app and do it soon

[Anonymous · Accepted solution]

you can use the concat function

this should work

sum({<

selection in set analysis={"$(=concat([Island Company],'","'))"}

>}

Value

[#5]

Thanks Rudolph, I will give it a try

[#6]

Great. That works perfectly, thanks!