Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>