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.

[MK_QSL]

Search for FirstSortedValue function

[gerry_hdm]

Firstsortedvalue

lastsortedvalue

by Group statement

[Anonymous]

Sir, do I write this in the Load Script or in the Expression tab?

[gerry_hdm]

by load script

[gerry_hdm]

MYTimestamp:

load OutageID,

firstsortedvalue(Timestamp) as FirstTimestamp,

firstsortedvalue(Timestamp) as FirstTimestamp

resident yourtable

group by OutageID

;

[gerry_hdm]

Greetings Gerold

[olivierrobin]

hello

for me , lastsortedvalue doesn't exist (that would be a good idea)

so i think you mean

MYTimestamp:

load OutageID,

firstsortedvalue(Timestamp,Timestamp) as FirstTimestamp,

firstsortedvalue(Timestamp,-Timestemp) as LastTimestamp

resident yourtable

group by OutageID

;

[gerry_hdm]

you can create a test.qvw ?

[sunny_talwar]

Would you be able to provide the Excel file above and also provide the expected output?