Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

Perhaps this blog post helps: The Master Time Table


talk is cheap, supply exceeds demand
Not applicable
Author

Not applicable
Author

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
Author

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