Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Max Date from 3 different dates

QV11 SR4

I'm wondering if there's a clever way of finding the most recent date of 3 dates.

I have 3 different dates (DD/MM/YYYY) from 3 different sources - a user could be in 1 or more source each with an assoicated address

depending upon which date is the most recent i want to use the address associated with that source.

I could probably do this in a lengthy IF statement but am wondering if there's a better way to go about it?

Want to do in the LOAD statement - all data in same table

Any pointers would be great.

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Max Date from 3 different dates

You can use RangeMax()

RangeMax(Date1, Date2, Date3)

View solution in original post

3 Replies
Highlighted

Re: Max Date from 3 different dates

You can use RangeMax()

RangeMax(Date1, Date2, Date3)

View solution in original post

Highlighted
Creator III
Creator III

Re: Max Date from 3 different dates

Knew they'd be something - many thanks

Highlighted

Re: Max Date from 3 different dates