Basic Set Analysis Examples - Simple Expressions Using Bookmarks

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

1
Calculate the average of "Sales" based on the server bookmark with the id "BM01".
Avg({Server\BM01}Sales)
2
Calculate the Sum of "Sales" based on the document bookmark with the id "BM01".
Sum({Document\BM01}Sales)
3
Calculate the sum of sales based on the current selection AND the server-bookmark with the Id "BM01".
Sum({$+Server\BM01}Sales)
4
Calculate the Sum of "Sales" based on the current selection except those records belonging to the bookmark with the Id 'Server\BM01'.
Sum({$-Server\BM01}Sales)

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