topic Replicating consecutive Timestamp in QlikView

Replicating consecutive Timestamp

Fri, 26 Feb 2016 20:24:52 GMT

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.

Re: Replicating consecutive Timestamp

swuehl — Fri, 26 Feb 2016 20:55:13 GMT

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

Re: Replicating consecutive Timestamp

Fri, 26 Feb 2016 21:06:47 GMT

Thanks for the response.

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

Thanks again and appreciate it.

Re: Replicating consecutive Timestamp

swuehl — Fri, 26 Feb 2016 21:20:37 GMT

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();

Re: Replicating consecutive Timestamp

johnw — Fri, 26 Feb 2016 23:40:03 GMT

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
;