The following examples use very simple and basic Set Analysis expressions.

5

Calculate the sum of "Sales" for **everything that the current selection excludes**.

Sum({1-$}Sales)

9

Calculate the **sum of the expression** "ItemsSold*ItemPrice" based on the **current
selection**.

*Note: Be carefull when using expressions within a Set Analysis expression!*

Sum({$}ItemsSold*ItemPrice)

© qlikblog.at / Stefan Walther 2020 ~ "Set Analysis Wizard for QlikView" Version 0.5