Qlikview Set Analysis

QlikView Set Analysis

What is Set Analysis? Why do we use it? How do we use it (syntax)? Examples

Set Analysis – What?

Aggregation functions normally aggregate over the set of possible records defined by the current selection. sum( Sales ) But an alternative set of records can be defined by a set expression. sum( {$} Sales )

Set Analysis – What?

Hence: 1. Conceptually similar to a selection. 2. Provides a method of defining groups (sets) of information that are independent of the current selections. 3. Can create sets based on other sets. 4. Must be used in aggregation function. 5. Always begin and end with curly brackets {}

Set Analysis – Why?

• Very powerful functionality for comparison analysis.

• This year vs. last year • Products purchased vs. not purchased

• May eliminate the need for additional, complex coding within an application

• No need for data islands (but data islands sometimes useful in conjunction with sets) • Reduces the need for macros

• Provides much more flexibility in the analysis’ you can create

• Expressions can be added for data outside of your current selection criteria

Set Analysis – How?

• The syntax is broken down into 3 categories:

1. Identifiers 2. Operators 3. Modifiers

Set Analysis – How?

• The syntax is broken down into 3 categories:

1. Identifiers sum({1 - $} Sales) sum({Bookmark01 } Sales)

Identifiers

0 1 $ $1 $_1 Bookmark01 - Represents an empty set - Represents the full set of all the records in the application - Represents the records of the current selection - Represents the previous selection - Represents the next (forward) selection - Represents the bookmark ID or the bookmark name

Identifiers

Examples: sum({1} Sales)

Returns total sales within the application, disregarding selections but not the dimension.

sum({$} Sales)

Returns sales for the current selection, i.e. the same as sum(Sales).

sum({$1} Sales)

Returns sales for the previous selection.

sum({Bookmark01}...