topic Re: Need Master Calendar script for timestamp in QlikView

Need Master Calendar script for timestamp

Fri, 27 Mar 2015 09:34:56 GMT

Hi,

Can any one please share the Master Calendar Script for the timestamp...

Regards,

Savi

Re: Need Master Calendar script for timestamp

Gysbert_Wassenaar — Fri, 27 Mar 2015 09:39:56 GMT

Perhaps this blog post helps: The Master Time Table

Re: Need Master Calendar script for timestamp

Fri, 27 Mar 2015 14:22:25 GMT

Calendar with time (timestamp)

Re: Need Master Calendar script for timestamp

Mon, 30 Mar 2015 06:39:30 GMT

Ya I tried this script, but this giving error in Qlikview 11.2. Could you please send me the script which works with QV 11.2 version...

Re: Need Master Calendar script for timestamp

Tue, 31 Mar 2015 09:43:14 GMT

Hi,

This has nothing to do with the version of QlikView. It worked for me but I had to take out the seconds from the TimeStamp format. With the seconds the variables vMinDate and vMaxDate got NULL value. Don't know why.

Floor(Min(TimeStamp#(timeStamp, 'YYYY-MM-DD hh:mm'))) AS MinDate,

Floor(Max(TimeStamp#(timeStamp, 'YYYY-MM-DD hh:mm'))) AS MaxDate

Hope it will work out for you too.

Best Regards
Fjalar