Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please share some sample file
Try with Time# function
The function to load an string as time is time#(Duration, 'hh:mm:ss') this will convert the string to a time field.
Regards
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);
Здравствуй,
Смотрите прикрепленный файл. В принципе , и поэтому поле обычно загружен. Может быть , это настройки QlikView на моем компьютере. В качестве обходного пути, вы можете создать текстовое поле (поле [NewDuration] в прикрепленном файле).
Regsrds,
Андрей
Use interval function:
LOAD
User,
interval(Duration) as Duration
FROM
[test.xlsx] (ooxml, embedded labels, table is Sheet1);