I have a table whose key is an ID and a Process Date The process Date can be any month between and including 01/01/2010 and 05/01/2010 Every ID should consist of five rows or Months between and including 01/01/2010 and 05/01/2010 The problem is there are gaps in the table's process dates. In this example were missing a row for ID A that has a Process Date or 03/01/2010 and X is missing a row with a Process Date of 02/01/2010. How do I programmatically fill in these gaps? I would assume I could do it with a nested loop but... I'm new to QlikView and I can't figure out the code. Any help with this would be greatly appreciated.
