4 Replies Latest reply: Nov 27, 2011 10:55 AM by Felipe Ruiz RSS

    Filter box table with set analysis

    Felipe Ruiz

      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

          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
            victor montero

            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
              Stefan Wühl

              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