Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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