Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can any one please share the Master Calendar Script for the timestamp...
Regards,
Savi
Perhaps this blog post helps: The Master Time Table
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...
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