Minimum Date Concatenate

[vidyasagar159]

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.

Month	Day	Year
1	15	2019
2	15	2019
3	15	2019

Thanks,

-Vidya

[rwunderlich]

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