Dear All,
i want to add missing months and populate the added fields in Qlikview data using the script only. I currently do not have a master calendar created for the dashboard.
If there are missing months. For example
MonthYear | StockMaterial | LGORT | StockQuantity |
Dec 2014 | 10037492 | D009 | 2 |
Nov 2014 | 10037492 | D009 | 14 |
Oct 2014 | 10037492 | D009 | 14 |
Sep 2014 | 10037492 | D009 | 12 |
Aug 2014 | 10037492 | D009 | 9 |
Jul 2014 | 10037492 | D009 | 10 |
Jun 2014 | 10037492 | D009 | 8 |
May 2014 | 10037492 | D009 | 0 |
Apr 2014 | 10037492 | D009 | 5 |
Mar 2014 | 10037492 | D009 | 1 |
Feb 2014 | 10037492 | D009 | 1 |
Oct 2013 | 10037492 | D009 | 8 |
Nov 13, Dec 13 and Jan 14, i want to first create these months in the data and then assign the next months stock quanity, which is 1 in this case of Feb'14.
Please help!
