Discussion board where members can get started with Qlik Sense.
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.
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.