Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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