Help me to create dummy dates for the remaining year.

[durgabhavani]

Hi All,

I have two fields ID and Date. Currently my straight table showing date upto current month (Mar 2018).Now I need to add dummy dates (Apr 2018, May 2018 ..... Dec 2018) for remaining year 2018 to my straight table. Please advice.

Current Output:

	Jan 2018	Feb 2018	Mar 2018
101
102
103
104
105

Expected Output:

	Jan 2018	Feb 2018	Mar 2018	Apr 2018	May 2018	Jun 2018	Jul 2018
101
102
103
104
105

Thanks,

Durga

[Chanty4u]

may be this Generating Missing Data In QlikView

[MarcoWedel]

search for "master calendar"