Basic Set Analysis Examples - Simple Expressions

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

1
Sum of "Sales" based on the current selection
Sum({$}Sales)
2
Count values of field "Customer" based on the current selection
Count({$}Customer)
3
Sum of "Sales" based on all values, ignoring any selection.
Sum({1}Sales)
4
Sum of "Sales" based on the bookmark with the ID "BM01".
Sum({BM01}Sales)
5
Calculate the sum of "Sales" for everything that the current selection excludes.
Sum({1-$}Sales)
6
Calculate the sum of "Sales" based on the previous selection.
Sum({$1}Sales)
7
Calculate the sum of "Sales" based on the next selection.
Sum({$_1}Sales)
8
Calculate the sum of "Sales" based on the 2nd previous selection.
Sum({$2}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 2017 ~  "Set Analysis Wizard for QlikView" Version 0.5