Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Merging Cells to form a Date

Hi,

I'm trying to merge several cells to form a fluid date, is this possible? As below:

Current:

YearMonthDayHourMinuteSecond
20156562530
201561115845

Needed:

DateHourMinuteSecond
5/06/201562530
11/06/201515845

Any help would be much appreciated!

Kind regards,

Tristan Breslin

1 Solution

Accepted Solutions
MVP
MVP

Re: Merging Cells to form a Date

LOAD

     MakeDate( Year,Month, Day) as Date,

     MakeTime(Hour, Minute, Second) as Time

FROM ...;

4 Replies
MVP
MVP

Re: Merging Cells to form a Date

LOAD

     MakeDate( Year,Month, Day) as Date,

     MakeTime(Hour, Minute, Second) as Time

FROM ...;

MVP
MVP

Re: Merging Cells to form a Date

To make date you can try MakeDate() function:

MakeDate(Year, Month, Day) as Date

Not applicable

Re: Merging Cells to form a Date

Great that's done it! Cheers Swuehl

Not applicable

Re: Merging Cells to form a Date

Cheers Sunny!