1 Reply Latest reply: Jan 15, 2015 4:54 AM by Gysbert Wassenaar RSS

    Add Missing Dates in data through Script

    Ali Haider

      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!