The Qlik Sense associative engine allows you to work with two states of selections: {1}
for all records with no selections applied, and {$}
for all records with current selections applied. They are also known as identifiers.
Considering these two states, we can create set expressions that ignore all selections except those you explicitly identify in your selection.
To take the concept a bit further, we will now see how to create a dashboard with objects that only accept selections in calendar fields.
For the purpose of this recipe, we make use of product sales data by invoice, as defined in the following inline data load. Load the following script in the Qlik Sense Data load editor
:
Transactions: Load date(today()-RowNo()) AS Date, Pick(Ceil(4*Rand()),'Apple','Orange','Lemon','Strawberry') AS Product, Pick(Ceil(2*Rand()),'Standard','Premium') AS ProductType, Round(1000 * Rand()) * Ceil(4*Rand()) AS Sales Autogenerate 1000; Calendar: ...