Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vidyasagar159
Creator II
Creator II

Minimum Date Concatenate

Hi All,

I have date values in three columns. Now I want to concatenate all three of them and get a Minimum date. Can someone please help me with the logic. Here is the sample data. This I want to achieve in the load script editor.

 

MonthDayYear
1152019
2152019
3152019

 

Thanks,

-Vidya

Labels (1)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The exact script depends on where you want to do this in the script and whether you need to group by some other values. But to get you started:

MakeDate(Year, Month, Day) as mydate

will create a proper date.

Date(Min(mydate)) as mindate

will return the minimum date.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com