Using search strings inside a set modifier

A set modifier contains one or several field names that make up the set expression. We can define a range of values within the selection made in the set modifier. The following recipe makes use of search strings to calculate sales within a specified date range.

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:

Sales: 
LOAD DATE(Date#(DeliveryDate,'DD/MM/YYYY')) AS DeliveryDate, 
DATE(Date#(ShipmentDate,'DD/MM/YYYY')) AS ShipmentDate, 
Customer,Month,Volume,Sales,Supplier INLINE [ 
Customer,Month,DeliveryDate,ShipmentDate,Volume,Sales,Supplier 
ABC,Jan,01/01/2015,29/12/2014,100,10000,DEF 
ABC,Feb,02/02/2015,25/01/2015,100,10000,DEF 
ABC,Mar,03/03/2015,02/03/2015,400,12000,DEF 
ABC,Apr,04/04/2015,24/01/2015,100,10000,GHI 
DEF,Feb,03/02/2015,03/02/2015,200,25000,GHI 
DEF,Mar,25/03/2015,21/03/2015,300,25000,GHI...