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

    How to use an expression value in set analysis



      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.



      Customer            status

      111222                A

      111333                B

      111444                A




      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.



      Sales_order     Sales

      837282            1000



      The qvw-file attached.



      Thanks in advance,