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.
What If Analysis
What is the –What If Analysis in QlikView...
