topic Re: Data islands and set analysis in QlikView

Data islands and set analysis

Tue, 22 Apr 2014 13:21:06 GMT

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?

Re: Data islands and set analysis

MK_QSL — Tue, 22 Apr 2014 13:31:46 GMT

Can you provide sample apps?

Re: Data islands and set analysis

Tue, 22 Apr 2014 13:36:53 GMT

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

Re: Data islands and set analysis

Anonymous — Tue, 22 Apr 2014 13:44:01 GMT

you can use the concat function

this should work

sum({<

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

Value

Re: Data islands and set analysis

Tue, 22 Apr 2014 13:48:40 GMT

Thanks Rudolph, I will give it a try

Re: Data islands and set analysis

Tue, 22 Apr 2014 13:56:21 GMT

Great. That works perfectly, thanks!