Ing Sistemas

QlikView Set Analysis

Tom Mackay
Senior Consultant

Agenda

1. 2. 3. 4.

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

Set Analysis – What?
Aggregationfunctions 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 setsbased 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 yearvs. 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 inconjunction 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 therecords 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)...