set analysis

The set analysis provides a means to define a set (or group) of data values that differ from the typical set that is determined by the current selections.

There is a defined syntax to the expression that defines the set analysis for a sheet object (charts, tables, lists, etc.). There are two requirements for set expressions in the Qlik sense: 

1. they must always be expressed inside closed curly brackets.
2. they can only contain aggregate functions like sum, average, count, mix, max, etc.

syntax of set analysis is:

Sum ({} Field)

for example:

we have data on the sales of the company in which order dates are available where min order date is 02/02/2010 and the max order date is 05/22/2017.

but we want to know the profit of those sales only which were ordered between 02/02/2010 to 28/05/2010.

the syntax would be:

= sum ({}[Total Profit])

A set expression is made up of a few of the components listed below:

1. Identifiers
2. Operators
3. Modifiers
4. Identifiers: The connection between the set expression and the things being evaluated in the remaining parts of the expression is defined by one or more identifiers. A basic set expression is made up of a single identifier, like the dollar symbol ($), which denotes all records in the current selection.

Examples: $, 1

in the above syntax: by default, $ is our identifier.

2._Operators: If there are several identifiers, an operator or operators are used to further define the data set by defining how the sets of data represented by the identifiers are combined, subset, or superset, for example.

Examples: +, -, *, /

in the above syntax: sum is our operator.

3._Modifiers: To alter the selection, a modifier or modifiers can be appended to the set expression. To filter the data set, a modifier can be used alone or in combination with an identifier.

Examples:

in the above syntax:

Reference URL: https://iqratechnology.com/
Reference URL: https://iqratechnology.com/qlik-sense-services/