topic Re: 3 Dates in Dataset - Need the Middle in QlikView

3 Dates in Dataset - Need the Middle

wonkymeister — Mon, 02 Aug 2021 14:48:44 GMT

Hi guys,

i have 3 dates in my dataset - of which i want to use the oldest two as labels.

i.e.

01/02/2021

13/05/2020

09/10/2019

the oldest is easy ie MIN(MyDateField). But whats the easy/quick way to get the middle date i.e. 13/05/2020?

Re: 3 Dates in Dataset - Need the Middle

Kushal_Chawda — Mon, 02 Aug 2021 15:26:40 GMT

@wonkymeister try below

MIN(MyDateField,2)

firstsortedvalue(MyDateField, MyDateField,2)

Re: 3 Dates in Dataset - Need the Middle

wonkymeister — Mon, 02 Aug 2021 16:35:50 GMT

Cheers, but the the first just pulls through the last date and the 2nd doesnt work?

Re: 3 Dates in Dataset - Need the Middle

Vegar — Mon, 02 Aug 2021 18:43:47 GMT

MIN(MyDateField,2) should work, but if it is not then median(MyDateField) could work in your case.

Re: 3 Dates in Dataset - Need the Middle

Kushal_Chawda — Mon, 02 Aug 2021 21:44:46 GMT

I think you said two statements. First, oldest two for which I already suggested solution. Second, middle date for which what Vegar suggested should work.

Re: 3 Dates in Dataset - Need the Middle

wonkymeister — Tue, 03 Aug 2021 07:47:30 GMT

Thanks for help guys!!!!!!