Enrolment options

Generating Missing Data (QS Feb 2020)

Auto Enrol

This module will explore scripting techniques to generate missing data.

Learning Objectives:

  • Propagate values from the previous record using Peek()
  • Generate records to fill gaps with IterNo() in a WHILE loop
  • Accumulate transactions to create a balance field
  • Split a delimited list of values into multiple records using SubField()
  • Use table join to generate Cartesian product
  • Monte Carlo simulations: Two thrown dice and initial poker hand
  • Explain functions used in Qlik’s Sample Data Script
  • Replace nulls using IsNull() and NullAsValue
Not logged in? or you may not have access to this course. Click the Continue button to login or click the browser's back button to return to the previous page.