Discussion Board for collaboration related to QlikView App Development.
i have 3 dates in my dataset - of which i want to use the oldest two as labels.
the oldest is easy ie MIN(MyDateField). But whats the easy/quick way to get the middle date i.e. 13/05/2020?
MIN(MyDateField,2) should work, but if it is not then median(MyDateField) could work in your case.
View solution in original post
@wonkymeister try below
Cheers, but the the first just pulls through the last date and the 2nd doesnt work?
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.
Thanks for help guys!!!!!!