topic Re: Calculate Time from 2nd Start Time in QlikView https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602368#M222685 <HTML><HEAD></HEAD><BODY><P>Excellent I did realize you could add the 2 to get the second value</P><P></P><P>thanks so much!</P><P></P><P>learning lots today</P></BODY></HTML> Tue, 18 Feb 2014 16:31:57 GMT rustyfishbones 2014-02-18T16:31:57Z Calculate Time from 2nd Start Time https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602365#M222682 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a list of values and I want to calculate the time from the 2nd Start Time and the End Time.</P><P></P><P>So in the below instance it will be from 8:00:12 that I need to calculate the time from</P><P></P><P><IMG alt="2014-02-18_1615.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/53425_2014-02-18_1615.png" /></P></BODY></HTML> Tue, 18 Feb 2014 16:18:22 GMT https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602365#M222682 rustyfishbones 2014-02-18T16:18:22Z Re: Calculate Time from 2nd Start Time https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602366#M222683 <HTML><HEAD></HEAD><BODY><P>Just to Clarify</P><P></P><P>The result I require is the next value after the MIN([Start Time])</P><P></P><P>Regards</P><P></P><P>Alan</P></BODY></HTML> Tue, 18 Feb 2014 16:21:04 GMT https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602366#M222683 rustyfishbones 2014-02-18T16:21:04Z Re: Calculate Time from 2nd Start Time https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602367#M222684 <HTML><HEAD></HEAD><BODY><P>Try the FirstSortedValue function</P><P>You have a last argument that returns the nth value you want.</P><P>Sth like FirstSortedValue(StartTime, StartTime, 2)</P><P></P><P>Fabrice</P></BODY></HTML> Tue, 18 Feb 2014 16:23:46 GMT https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602367#M222684 2014-02-18T16:23:46Z Re: Calculate Time from 2nd Start Time https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602368#M222685 <HTML><HEAD></HEAD><BODY><P>Excellent I did realize you could add the 2 to get the second value</P><P></P><P>thanks so much!</P><P></P><P>learning lots today</P></BODY></HTML> Tue, 18 Feb 2014 16:31:57 GMT https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602368#M222685 rustyfishbones 2014-02-18T16:31:57Z Re: Calculate Time from 2nd Start Time https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602369#M222686 <HTML><HEAD></HEAD><BODY><P>I learnt it 5 days ago !!</P></BODY></HTML> Tue, 18 Feb 2014 16:32:52 GMT https://community.qlik.com/t5/QlikView/Calculate-Time-from-2nd-Start-Time/m-p/602369#M222686 2014-02-18T16:32:52Z