Filter box table with set analysis

[julruiz123]

I was wondering if is possible to filter a box table using set analysis.

Example:

Table 1:

Field1     Field2

1               Felipe

2               Juan

3               Geral

4               Michael

5               Lily

6               Avril

7               Julian

Table 2:

Field3     Field4

2               Juan

5               Lily

7               Julian

Then i need use a box table that shows the records of table1 that exist in table2. (The tables is not related)

Ps: I know that is a stupid example but i need it to other situation.

Thanks.

[#2]

Not sure if this is what you are looking for...

You could use one of the following search strings together with an OnOpen trigger or a button (select in field action)

= '(' & Concat(Field3, '|') & ')'    => possible values without set analysis (same result as next example)
= '(' & Concat({$}Field3,'|') & ')' => possible values with set analysis
= '(' & Concat({1}Field3,'|') & ')' => all values with set analysis

[montero91]

I hope you understand the question, first load your board Base or reference

example:

Table 1:
Load
field1,
field2

And in the second load it with WHERE EXISTS

example

Table2
load
Field3,
field4
from x.qvd

WHERE Exists (Field1, Field3),

and clears the table that you don´t need

example
DROP TABLE table1;

[swuehl · Accepted solution]

julruiz123,

if you don't want a triggered action to filter your table box and you don't want to filter in your load, I think you can use a set expression, but not in a table box, but in e.g. straight table chart.

Use Field1 and Field2 as dimensions, and then either

=sum({<Field1=p(Field3)> }1)

or

sum({<Field1=p({1} Field3)> }1)

depending on if want you this expression to be sensitive to selections on Field3 or not. You could hide this expression in presentation tab, so you get a similar look as with a table box.

Please see attached ( I just added these two charts to staffelbachs sample ),

Stefan

[julruiz123]

Thanks swuehl,

It worked perfectly!