Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
wonkymeister
Creator II
Creator II

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 II
Creator II
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 II
Creator II
Author

Thanks for help guys!!!!!!