## 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 2021 ~  "Set Analysis Wizard for QlikView" Version 0.5