back to qlikblog.at

Basic Set Analysis Examples - Simple Expressions

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

Sum of "Sales" based on the current selection

Sum({$}Sales)

Open wizard

Count values of field "Customer" based on the current selection

Count({$}Customer)

Open wizard

Sum of "Sales" based on all values, ignoring any selection.

Sum({1}Sales)

Open wizard

Sum of "Sales" based on the bookmark with the ID "BM01".

Sum({BM01}Sales)

Open wizard

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

Sum({1-$}Sales)

Open wizard

Calculate the sum of "Sales" based on the previous selection.

Sum({$1}Sales)

Open wizard

Calculate the sum of "Sales" based on the next selection.

Sum({$_1}Sales)

Open wizard

Calculate the sum of "Sales" based on the 2nd previous selection.

Sum({$2}Sales)

Open wizard

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)

Open wizard