topic Filter box table with set analysis in QlikView

Filter box table with set analysis

julruiz123 — Fri, 25 Nov 2011 23:02:15 GMT

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.

Re: Filter box table with set analysis

Sat, 26 Nov 2011 07:23:45 GMT

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

Filter box table with set analysis

montero91 — Sat, 26 Nov 2011 14:52:28 GMT

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;

Re: Filter box table with set analysis

swuehl — Sat, 26 Nov 2011 15:08:26 GMT

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)

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

Filter box table with set analysis

julruiz123 — Sun, 27 Nov 2011 15:55:21 GMT

Thanks swuehl,

It worked perfectly!