Set Analysis expressions tend to become overly complex when there are too many comparison sets and conditions put in place. In order to reduce the complexity, you can make use of the flags created in the script in the Set Analysis expression. The flags can be set up to be simple binary values, 0 and 1. The use of flags optimizes the performance of frontend calculations. The following recipe explores this possibility by creating flags in the script to identify On-time and Late shipments.
Using flags in Set Analysis
Getting ready
For the purpose of this recipe, we will be using an inline data load that contains shipment details for each customer. Load the following script in the Qlik Sense Data load editor:
SalesTemp: LOAD...