Time master calendar

[#1]

Hello,

I have been reading and following this great blog by HIC, but now he confused me even more.

Can someone help me with the script?

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/23/the-master-time-table?et=blogs.comment...

I dont get the last part he says.

[#2]

Attached there is an example:

The top chart shows data by TimeCalendar

The buttom chart shows by loading distinct values - and this one is correct!

Why do i get null values in my TimeCalendar?

New version uploaded

[#3 · Accepted solution]

TempTime:

Load

Time(RecNo() /24/60 as TimeNum

AutoGenerate 24*60;

Time:

Load

Time(TimeNum,'hh:mm') as Time,

Hour(TimeNum) as Hour,

Minute(TimeNum) as Minute

Resident TempTime; Drop table TempTime;

That worked for me.

[#4]

I think you key Time is wrong:

Try with this:

TempTime:

Load

(RowNo()-1 / 24 / 60 as TimeNum

AutoGenerate 24*60;

Time:

Load

Floor(TimeNum, 0.0000001) as Time,

Hour(TimeNum) as Hour

Resident TempTime; Drop table TempTime;

and the make a floor in Hej table.

Time(floor(CreateDate,0.0000001) as Time,