Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem of time field

hi guys,

i have two time fields  : time_field1=120:00:00 and the second one is time_field2= 07:21:54 .

when i create a text object and in the text field i put 07:21:54 -120:00:00 i got -4,69 and this is the right value.

but when i put it in the load by thier fields name,that's mean

load

time_field2-120:00:00 as toto

i've got another value.

any suggestions??????

5 Replies
Gysbert_Wassenaar

Try: time_field2- interval('120:00:00','h:mm:ss') as toto


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

You  can  try

interval(time_field2-time_field1,'hh:mm:ss')

maxgro
MVP
MVP

t:

load * inline [

time_field2, time_field1

07:21:54, 120:00:00

];

t2:

load

  time_field2 - time_field1 as toto

Resident t;

1.png

Not applicable
Author

It doesnt work guys i ve got. Anothervalue

MarcoWedel

please post sample app/data