topic Re: Re: Time master calendar in QlikView

Time master calendar

Tue, 11 Feb 2014 15:36:08 GMT

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?

I dont get the last part he says.

Tue, 11 Feb 2014 17:34:34 GMT

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

Tue, 25 Mar 2014 08:47:42 GMT

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.

Tue, 25 Mar 2014 10:54:23 GMT

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,