Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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;
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
Thanks swuehl,
It worked perfectly!