Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Need Master Calendar script for timestamp

Hi,

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

Regards,

Savi

4 Replies

Re: Need Master Calendar script for timestamp

Perhaps this blog post helps: The Master Time Table


talk is cheap, supply exceeds demand
Not applicable

Re: Need Master Calendar script for timestamp

Not applicable

Re: Need Master Calendar script for timestamp

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...

Not applicable

Re: Need Master Calendar script for timestamp

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

Community Browser