1 Reply Latest reply: Apr 1, 2010 12:07 PM by MManders RSS

    bar chart

    dcroft

      Hi,

      I am trying to product a bar chart which shows me, for each Product bought by a customer, other Products also bought by the same customer

      The simplified data model has 2 tables Cust and Order joined by Cust Id

      Product resides on the Order table.

      Can anyone help me with this?

      Cheers

        • bar chart
          MManders

          Sounds like you could use Indirect Set Analysis. There is a qvw available that shows a lot of set analysis samples, including Indirect Set Analysis.

          Basically you can select values based on a sub selection.

          For instance (from the mentioned Set Analysis.qvw)

           

          sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>} CompanyName)>} Sales)

           


          Sales for Customers who purchased Baby Clothes.
          The set p({}) returns the values of CompanyName (Customer) that purchased Baby Clothes. </body>