Manage Time

[Anonymous]

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

[prma7799]

Please share some sample file

[prma7799]

Try with Time#  function

[jmvilaplanap]

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

Regards

[MK_QSL]

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);

[ahaahaaha]

Здравствуй,

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

Regsrds,

Андрей

[micheledenardi]

Use interval function:

LOAD

     User,

    interval(Duration) as Duration       

FROM

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