topic Re: problem of time field in QlikView

problem of time field

Fri, 24 Oct 2014 10:44:23 GMT

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??????

Gysbert_Wassenaar — Fri, 24 Oct 2014 16:53:21 GMT

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

Anonymous — Fri, 24 Oct 2014 17:58:13 GMT

You can try

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

maxgro — Fri, 24 Oct 2014 19:00:51 GMT

load * inline [

time_field2, time_field1

07:21:54, 120:00:00

];

t2:

load

time_field2 - time_field1 as toto

Resident t;

Fri, 24 Oct 2014 19:06:32 GMT

It doesnt work guys i ve got. Anothervalue

MarcoWedel — Fri, 24 Oct 2014 19:46:58 GMT

please post sample app/data