Creating a multi-measure expression in Set Analysis

Sometimes, you may have groups of expressions you want to view that either don't need to be viewed at once, or you don't have the room to display them all. In these cases, you do not have to go and create another sheet; you can add a control to let users select what is calculated.

The output of this recipe is similar to the preceding recipe, only with slightly different expressions to add depth of analysis to the same object.

Getting ready

For the purpose of this recipe, we make use of product sales and margin data, as defined in the following script. Load the following data into the Qlik Sense Data load editor:

Transactions: 
Load  
Date(today()-IterNo()) AS Date, 
Pick(Ceil(3*Rand()),'Standard','Premium','Discount') AS 
   ProductType, 
Floor(date(today()-IterNo())) AS DateNum, 
 Round(1000*Rand()*Rand()*Rand()) AS Sales, 
 Round(10*Rand()*Rand()*Rand()) AS Quantity, 
 Round(Rand()*Rand(),0.00001) AS Margin 
Autogenerate 10000 
While Rand...