Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
tomcatxx
Contributor

Time Calendar for every second of 24hours

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

1 Solution

Accepted Solutions

Re: Time Calendar for every second of 24hours

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));

View solution in original post

3 Replies

Re: Time Calendar for every second of 24hours

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));

View solution in original post

tomcatxx
Contributor

Re: Time Calendar for every second of 24hours

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

Re: Time Calendar for every second of 24hours

Sure thing!!