Generate Missing Months based on date

[DS14]

I have date field, from which I have to generate months which are not exists in data for the year.

For Example:

Date
01-11-2017
05-07-2018
01-08-2018
07-08-2018
01-10-2018
14-10-2018
01-12-2018
16-12-2018
01-01-2019
20-01-2019

Like in existing date field, December for the year 2017 and Jan,Feb,March,April,May,June and September for the year 2018 is not available. Now I have to create all those months in data.

Please suggest how I can achieve this.

Thanks in advance.

[pradosh_thakur]

Month(Date(date_field,dateformat),'MMM')

Month(Date(Date,'DD-MM-YYYY'),'MMM')

[DS14]

Hi Pradosh,

Thanks for  the quick response.

I am asking for creating missing months which does not exists in existing date field.

[OmarBenSalem]

Create a master calendar.

Please refer to this:

https://community.qlik.com/t5/QlikView-Scripting/Creating-A-Master-Calendar/td-p/341286

ps: there are at least hundred of threads discussing master calendars; u should take a look

[pradosh_thakur]

Oh !! Sorry I missed that . Please create a master calender for this.

[siddharthsoam]

You just need to link date field in your base with date in master calendar