Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
wonkymeister
Creator
Creator

3 Dates in Dataset - Need the Middle

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?

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

5 Replies
Kushal_Chawda

@wonkymeister  try below

MIN(MyDateField,2)

or

firstsortedvalue(MyDateField, MyDateField,2)

wonkymeister
Creator
Creator
Author

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

Vegar
MVP
MVP

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Kushal_Chawda

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.

wonkymeister
Creator
Creator
Author

Thanks for help guys!!!!!!