Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Your dates need to read in having a numeric representation, set the default time format or use date#() function if needed.
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;
Its got succeed with Rangemax() function. Thank you very much.