title: Qlikview Calculated Fields with Load Script
body: <p>I am currently using the following calculated field in a Qlikview pivot table. </p>
  
  <pre><code>=if([Event Type] = 'PO',date(MonthStart([EvtDt.Date Code]-15), 'YYYY-MMM'),if([Event Type]   = 'WO',date(MonthStart([EvtDt.Date Code]-50), 'YYYY-MMM'), if([Event Type] = 'BFT PLAN',date(MonthStart([EvtDt.Date Code]), 'YYYY-MMM'))))
  </code></pre>
  
  <p>Is it possible to pre-calculate this field, perhaps in a LOAD script, so that the field in the pivot table is simply the date value?</p>