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.
ID Process Date
A 01/01/2010
A 02/01/2010
A 04/01/2010
A 05/01/2010
...
X 01/01/2010
X 03/01/2010
X 04/01/2010
X 05/01/2010
