Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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;


Not applicable
Author

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