Time Calendar for every second of 24hours

[tomcatxx]

Hi there, I need a Time calendar which shows time from 00:00:00 to 23:59:59. I tried to write one. But it not works

--------------------------------------------------------------------------

Let S_Interval_Sekundär = 1;

Uhrzeit_Kalender:
LOAD
Time(frac(Kalender_Uhrzeit)) AS Uhrzeit,
Hour(Kalender_Uhrzeit) AS Kalender_Stunde,
Minute(Kalender_Uhrzeit) AS Kalender_Minute,
Second(Kalender_Uhrzeit) AS Kalender_Sekundär;

LOAD
Time(Time#(Recno() * $(S_Interval_Sekundär), 's')) AS Kalender_Uhrzeit
AutoGenerate ((24*60*60) / $(S_Interval_Sekundär)) - 1;

-------------------------------------------------------------------------------------------------------

Who can help me to correct it or write a new one?

Rrgards

[sunny_talwar · Accepted solution]

I am not sure what exactly the issue is... but when I run this (slightly modified version from yours... I get 00:00:00 to 23:59:59.

LET S_Interval_Sekundär = 1;

Table:

LOAD Time(Time#((Recno()-1) * $(S_Interval_Sekundär), 's')) AS Kalender_Uhrzeit

AutoGenerate ((24*60*60) / $(S_Interval_Sekundär));

[tomcatxx]

Thank you very much. But I I have another question about that. I will show it as a new question in  'New to Qlikview'.

[sunny_talwar]

Sure thing!!