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)
Open wizard
2
Calculate the Sum of "Sales" based on the document bookmark with the id "BM01". 
Sum({Document\BM01}Sales)
Open wizard
3
Calculate the sum of sales based on the current selection AND the server-bookmark with the Id "BM01". 
Sum({$+Server\BM01}Sales)
Open wizard
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)
Open wizard

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