This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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!!!!!!