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.
