topic Re: Manage Time in QlikView

Manage Time

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

Hi guys,

I've a table with field Duration, the data is a time, for example:

User	Duration
A	36:10:45
B	12:45:29
C	45:55:26

36:10:45

where first part are hours, second are minutes and the third are seconds.

Now when I load this field there are two ways, first:

load Duration

from ....

but the result is a single number, for example 15,54, and I don't want this;

second:

load Time(Duration, 'hh:mm:ss') as duration

from ...

but if the source value is 36:10:45, qlikview load 12:10:45, and I don't want this.

I'd like to get this result: 36:10:45.

It's possible?

Thanks

Re: Manage Time

prma7799 — Mon, 03 Jul 2017 09:52:21 GMT

Please share some sample file

Re: Manage Time

prma7799 — Mon, 03 Jul 2017 09:54:44 GMT

Try with Time# function

Re: Manage Time

jmvilaplanap — Mon, 03 Jul 2017 09:57:53 GMT

The function to load an string as time is time#(Duration, 'hh:mm:ss') this will convert the string to a time field.

Regards

Re: Manage Time

MK_QSL — Mon, 03 Jul 2017 09:59:08 GMT

OAD User,

Time#(Duration,'hh:mm:ss') as Duration

FROM

[https://community.qlik.com/thread/266243]

(html, codepage is 1252, embedded labels, table is @1);

Re: Manage Time

ahaahaaha — Mon, 03 Jul 2017 10:11:04 GMT

Здравствуй,

Смотрите прикрепленный файл. В принципе , и поэтому поле обычно загружен. Может быть , это настройки QlikView на моем компьютере. В качестве обходного пути, вы можете создать текстовое поле (поле [NewDuration] в прикрепленном файле).

Regsrds,

Андрей

Re: Manage Time

micheledenardi — Mon, 03 Jul 2017 10:17:48 GMT

Use interval function:

LOAD

User,

interval(Duration) as Duration

FROM

[test.xlsx] (ooxml, embedded labels, table is Sheet1);