How to get maximum and minimum timestamp?

[Anonymous]

Hey guys! I have a Start Date and End Date which has Start time and End time respectively. My task is to get the minimum and maximum timestamp for each outage, excluding Duration Type and Major Event Day (MED).

Here's how my data set looks like:

I tried min(timestamp#([Start Date],[Start Time],[Outage ID])) and max(timestamp#([Start Date],[Start Time],[Outage ID])) to no avail. I am a QlikView newbie so I'm sorry if I missed something obvious and thanks for your response in advance.

[Anonymous]

Sir, this is how my load script looks like:

Do I write the MYTimestamp script after From? or below Load Outage ID?

[Anonymous]

Hi Sir please see attached file.

Thank you.

[Anonymous]

Also, the data should be presented in a Straight Table.

[gerry_hdm]

you are Setting a correctly timestamp

Directory;
DATEMAXMININPUT:
LOAD [Outage ID] ,
[Start Date]  ,
[Start Time]  ,
timestamp(Timestamp# (text(date([Start Date],'DD.MM.YYYY')) & text(time([Start Time],'hh:mm:ss')) ,'DD.MM.YYYYhh:mm:ss' ),'DD.MM.YYYY hh:mm:ss')  as START_Timestamp  ,
[End Date]  ,
[End Time]  ,
timestamp(Timestamp# (text(date([End Date],'DD.MM.YYYY')) & text(time([End Time],'hh:mm:ss')) ,'DD.MM.YYYYhh:mm:ss' ),'DD.MM.YYYY hh:mm:ss')  as END_Timestamp  ,
[Duration Type],
[Major Event Day],
[General Cause]
FROM
[Excel File.xlsx]
(ooxml, embedded labels, table is Data);

TimeStamp:
load *,
(maxTIMESTAMP - minTIMESTAMP) *60 *24 as Duration
;

Load
[Outage ID],
min(START_Timestamp) as minTIMESTAMP,
Max(END_Timestamp) as maxTIMESTAMP
resident DATEMAXMININPUT 
group by [Outage ID];

[Anonymous]

Hi Sir, unfortunately it isn't working

[gerry_hdm]

here is a example

[Anonymous]

Sorry to say Sir but I'm using Personal version so I can't open the file on QlikView