Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

Calculate Time from 2nd Start Time

Hi All,

I have a list of values and I want to calculate the time from the 2nd Start Time and the End Time.

So in the below instance it will be from 8:00:12 that I need to calculate the time from

2014-02-18_1615.png

1 Solution

Accepted Solutions
Not applicable

Try the FirstSortedValue function

You have a last argument that returns the nth value you want.

Sth like FirstSortedValue(StartTime, StartTime, 2)

Fabrice

View solution in original post

4 Replies
rustyfishbones
Master II
Master II
Author

Just to Clarify

The result I require is the next value after the MIN([Start Time])

Regards

Alan

Not applicable

Try the FirstSortedValue function

You have a last argument that returns the nth value you want.

Sth like FirstSortedValue(StartTime, StartTime, 2)

Fabrice

rustyfishbones
Master II
Master II
Author

Excellent I did realize you could add the 2 to get the second value

thanks so much!

learning lots today

Not applicable

I learnt it 5 days ago !!