Getting ready

For the purpose of this recipe, we will make use of the sales information for different fruits, as defined in the script:

  1. Create a new Qlik Sense application and call it QS_DynamicCharts.
  2. Load the following data into the Data load editor:
Transactions: 
Load  
 Mod(IterNo(),26)+1 AS Period, 
 Pick(Ceil(3*Rand()),'Standard','Premium','Discount') AS 
ProductType, Pick(Ceil(6*Rand()),'Apple','Orange','Cherry','Plum','Fig',
'Pear') AS Category, Pick(Ceil(3*Rand()),'Heavy','Medium','Light') AS Weight, Pick(Ceil(2*Rand()),'2013','2014') AS Year, Round(1000*Rand()*Rand()*Rand()) AS Sales Autogenerate 20 While Rand()<=0.5 or IterNo()=1; SET vDimension = 'GetFieldSelections(Dimensions)'; Dimensions: LOAD * INLINE [ Dimensions Weight ProductType Category ];
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset