Replicating consecutive Timestamp

[#1]

Hi Community,

I have table like below.

I would like to replicate the time stamp monthly. I tried using autogenerate() i didn't work out for me.

[swuehl]

I think you can maybe use WHILE clause in your LOAD to generate the missing records.

See also:

Generating Missing Data In QlikView

[#3]

Thanks for the response.

Can you please tell me how to implement the logic.I am new to qlikview.

Thanks again and appreciate it.

[swuehl]

I am not sure how your expected result looks like, but here is an example for a WHILE clause in a LOAD statement, generating missing monthly records up to today:

SET DateFormat='DD.MM.YYYY';

LOAD *, AddMonths(Date, iterno()-1) as NewDate INLINE [
Date
26.02.2016
01.12.2015
]
WHILE AddMonths(Date, iterno()-1) <= today();

[johnw · Accepted solution]

Are you just trying to generate a bunch of months?

LOAD
recno() as ID
,timestamp(addmonths(makedate(2013,9),recno()),'M/D/YYYY h:mm') as Timestamp
AUTOGENERATE 65
;