1 Reply Latest reply on Dec 23, 2016 3:01 AM by Aurelien Jacques

    Use a view as a filter in a second view

    Aurelien Jacques

      Hello everyone,

       

      I would like to use a view as a filter.

       

      I have a list of Materials in different Experiments. Each couple of Experiment/Material has a status.

      First, I would like to filter the experiments depending on a selected material and then filter on the status (Status=’T’) but also display the selected material.

       

      In the below example, if I select Material = ‘10A’, my list of experiments is (4GC200A, 4GC300A).

      In these two experiments, I want to display rows with Material = ‘10A’ or Status=’T’.

       

      Experiment

      Material

      Status

      YEAR

      MOI

      RDT

      4GC100A

      20A

      S

      2014

      2

      20

      4GC100A

      30A

      S

      2014

      3

      50

      4GC100A

      40A

      T

      2014

      4

      40

      4GC200A

      10A

      S

      2014

      5

      60

      4GC200A

      20A

      T

      2014

      8

      20

      4GC200A

      30A

      S

      2014

      6

      80

      4GC200A

      40A

      S

      2014

      2

      90

      4GC300A

      10A

      S

      2014

      4

      470

      4GC300A

      20A

      T

      2014

      3

      20

      4GC300A

      30A

      T

      2014

      8

      660

      4GC300A

      40A

      T

      2014

      10

      512

       

      I attached a simplified workbook.

       

      In the view ‘Filter’, I have the list of Experiment depending on the Material Selected.

       

      In the view ‘Result’, I would like to filter the experiments depending on the first view and then apply the second filter : Material = ‘10A’ or Status=’T’.

      The issue is that I have only the Material Selected.

       

      How could I do that?

       

      I attached a simplified workbook.

       

      Your help is kindly appreciated.

       

      Ce message a été modifié par : Aurelien Jacques

        • 1. Re: Main filter and secondary filter
          Matthew Risley

          Aurelien,

           

          adding a workbook in this case may be best. Looking at your table, we are unsure of what the pills are or what your dimensions/measures look like. This is a good link on how to get the most out of forums

          So Your Question Didn't Get Answered... 

           

          If Material, and Status are dimensions, you can just drag them to filters and filter on "1" and "T"

           

          or you could create a calculated field similar to:

           

          Material = 1  -> then drag to filters and select "true"

          and

          Status = 'T' -> then drag to filters and select "true"

           

          Hope this helps