topic Re: Converting Date format + Time format into a combined string in QlikView

Converting Date format + Time format into a combined string

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Timestamp is used to convert string into Date formats and Time formats. I'd like to find a way to do it the other way around.

Example below :

Date: Time:

11/06/2016 14:12:15 PM

Lets say I am interested in knowing the when the first date of sale of an article was or the last date. Thus i was thinking of simply using Max(date) and Max(time) and min(date) min (time). I can use this because the sheet object I am using to show the data is a pivot table, thus it would relate it properly to the relevant article. However, I wish to represent the Article in one column and (date and time) in another.

Can someone please give any advice on how I can combine the date and time in their relevant formats as in the example?

Max(date) & '' & Max(time) did not yield the required results, I am assuming it because of the formatting issues.

Thanks in Advance !

Re: Converting Date format + Time format into a combined string

sunny_talwar — Mon, 13 Jun 2016 12:56:22 GMT

Why not just do it in the script:

TimeStamp(Date + Time) as TimeStamp

and then may be Max(TimeStamp)

Re: Converting Date format + Time format into a combined string

Anonymous — Mon, 13 Jun 2016 13:01:09 GMT

Where do i do it in the script?

If i do it underneath the Load statement, it doesnt work.

See below example of the script:

LOAD

[Confirmation Date],

[Confirmation Time],

Timestamp([Confirmed Date] + [Confirmed Time]) as Timestamp,

It says that Confirmed Date doesn't exist.

Re: Converting Date format + Time format into a combined string

sunny_talwar — Mon, 13 Jun 2016 13:09:27 GMT

May be this:

LOAD

[Confirmation Date],

[Confirmation Time],

Timestamp([Confirmation Date] + [Confirmation Time]) as Timestamp,

Re: Converting Date format + Time format into a combined string

Anonymous — Mon, 13 Jun 2016 13:13:23 GMT

Thanks Alot ! Rookie Error. Works like a charm