Set Analysis Examples - Basic Set Modifiers

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

1
Returns the sales for region US disregarding/overriding the current selection in field "Region".
sum({1<Region = {'Eastern'}>} Sales)
2
Returns the sales for current selection, but with the selection in "Region" removed.
sum({$<Region = >} Sales)
3
Calculate the Sum of Sales based on the current selection but exclude the product category "Confections" (field "ProductCategory").
Sum({$<ProductCategory-={'Confections'}>}Sales)
4
Sum of Sales based on the current selection, but only consider Sales in the 1980's.
Sum({$<Year={'198*'}>}Sales
5
Sum of Sales based on the current selection, but only consider years from 2000 to 2009, but exclude 2010, 2011, etc.
Sum({$<Year={'200*'}>}Sales)
6
Sum of Sales based on the current selection, but only consider the years 1970, 1980, 1990, etc.
Sum({$<Year={'19?0'}>}Sales)
7
Sum of Sales based on the current selection, but consider only years greater than max(Year) and less than min(Year), so if you are having 2008, 2009, 2010 only the Sales of 2009 would be calculated.
Sum({$<Year={">$(=min(Year))<$(=max(Year))"}>}Sales)
© qlikblog.at / Stefan Walther 2017 ~  "Set Analysis Wizard for QlikView" Version 0.5