Set Analysis Examples - Indirect Set Modifiers/Indirect Set Analysis

These examples demonstrate the advanced technique of indirect sets.

1
Returns the Sum of Sales for the current selection, but only for those customers that have bought the product "Shoe".
(This is one of the examples of the "QlikView Help").
Sum({$<Customer=P({1<Product={'Shoe'}>}Customer)>}Sales)
2
Return the Sum of Sales for the current selection, but only for those customers who have ever supplied the product "Shoe".
Sum({$<Customer=P({1<Product={'Shoe'}>}Supplier)>}Sales)
© qlikblog.at / Stefan Walther 2017 ~  "Set Analysis Wizard for QlikView" Version 0.5