Using flags in Set Analysis

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.

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 DATE(Date#(DeliveryDate,'DD/MM/YYYY')) AS DeliveryDate, 
DATE(Date#(ShipmentDate,'DD/MM/YYYY')) AS ShipmentDate, 
Invoiceno.,Customer,Month,Sales INLINE [ 
Invoiceno.,Customer,Month,DeliveryDate,ShipmentDate,Sales 
101,ABC,Jan,01/01/2015,29/12/2014,10000 
102,ABC,Feb,02/02...