8 Replies Latest reply: Oct 12, 2012 11:38 AM by samikalliola RSS

    How to use an expression value in set analysis

      Hi

       

      Is it possible to create a set analysis expression that uses value from a chart row?

       

      I have two data sources Table1 and Table2. Table1 contains Customer and status information. Table2 contains sales orders and the link information that contains customer numbers.

       

      Table1:

      Customer            status

      111222                A

      111333                B

      111444                A

       

       

      Table2:

      Sales_order    Link          Sales         

      837282          111222      1000

      364827          111333      2000

      384634          removed      500

       

      I need a chart that only shows the sales from customers with status A. The result would look like this.

       

      Chart:

      Sales_order     Sales

      837282            1000

       

       

      The qvw-file attached.

       

       

      Thanks in advance,

      Sami