Indirect Set Analysis
Set analysis was previously restricted to stating direct selections in a
field.
Starting with version 9, it is now possible to state selections in a field
based on selections in another field.
The functions p() and e() can be used to select the set of possible or
excluded values within a field.
Indirect Set Analysis
• p( ) = Possible
• e( ) = Excluded
Excluded
Possible
Customer = p({<Year={$(=max(Year)-1)}>} Customer)
Returns customers who had an association to last year.
sum(({<Year={$(=max(Year))},
Customer = p({<Year={$(=max(Year)-1)} Customer>}) Sales)
Returns this year's sales for customers who had sales last year
Indirect Set Analysis
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.
sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}
CompanyName) - p({$<CategoryName={'SportsWear'}>}
CompanyName)>} Sales)
Sales for Customers who purchased Baby Clothes but not
Sportswear.The first set p({}) returns CompanyName that purchased
Baby Clothes.The second set p({}) returns CompanyName that
Purchased SportsWear.The Unary Operator "-" between the two gives
a list of Customers (CompanyName)that belong to the first but not the
other set.
Regards,
Ajay
