Identifiers

Identifiers define the relationship between the set expression and the field values or expression being evaluated.

The following values can be used as identifiers:

Identifier Description
1 Represents the full set of all the records in the application, irrespective of any selections made. This means the whole data model.
$ Represents the records of the current selection. The set expression {$} is thus the equivalent to not stating a set expression. For example: sum({$} [Product Value]) is the same as sum([Product Value]).
$n Represents the n previous selections. Example: count ({$1} [User Id]) disregards the current selection made by the user and instead counts the [User Id] in the user's previous selection.
$_1 Represents the next (forward) selection. This is only valid when more than two selections have been made.
BM01 You can use any bookmark ID or bookmark name.
MyAltState You can reference the selections made in an alternate state by its state name. Alternate states aren't available out of the box in the Qlik Sense September 2017 release or before. 
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.137.184.102