topic Help me to create dummy dates for the remaining year. in QlikView

Help me to create dummy dates for the remaining year.

durgabhavani — Thu, 29 Mar 2018 12:46:28 GMT

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

Re: Help me to create dummy dates for the remaining year.

Chanty4u — Thu, 29 Mar 2018 12:50:38 GMT

may be this Generating Missing Data In QlikView

Re: Help me to create dummy dates for the remaining year.

MarcoWedel — Thu, 29 Mar 2018 23:52:39 GMT

search for "master calendar"