Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Maximum value among series of date columns in source data

Hi.

I have five different columns in the base data which i have loaded into Qlikview as source data. Out of these five columns values (dates), i want to  have the latest or maximum date and this date should be inserted in new column (into table).

Can any one please guide me---how to do

Thanks and regards

Aditya

(India)

2 Replies
Highlighted
MVP
MVP

Re: Maximum value among series of date columns in source data

Your dates need to read in having a numeric representation, set the default time format or use date#() function if needed.

Get the Dates Right

Why don’t my dates work?

Then you can use Rangemax() to get the max date and format it as date if you want:

LOAD

     DateField1,

     DateField2,

     DateField3,

     DateField4,

     DateField5,

     Date( RangeMax(DateField1, DateField2, DateField3, DateField4, DateField5 ) ) as MaxDate

FROM YourSource;


Highlighted
Not applicable

Re: Maximum value among series of date columns in source data

Its got succeed with Rangemax() function. Thank you very much.