Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Add Missing Dates in data through Script

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!

Tags (2)
1 Reply
Gysbert_Wassenaar
Not applicable

Re: Add Missing Dates in data through Script

See this document: Generating Missing Data In QlikView


talk is cheap, supply exceeds demand
Community Browser