[Urgent]Scripting error

n1ef5ng1 — Wed, 15 May 2013 01:35:39 GMT

Hi gurus,

I have two time field, Arrival Time and Expected Arrival Time.

I need to find the difference of this two time,

say expected arrival time is 9am and arrival time is 11am, the output should be -2 (Delay)

expected arrival time is 11am and arrival time is 9an, output should be 2 (early)

However, all my output, whether is it early or delay, do not have negative sign in it. (like absolute value)

any help?

here is my code,

if(LOAD_ATB_DT >TSA_COD , ( interval#(timestamp(LOAD_ATB_DT)-timestamp(TSA_COD),'mm')), (interval#(timestamp(LOAD_ATB_DT)-timestamp(TSA_COD),'mm' ) ) ) as Tranship_Dwell,
if(LOAD_ATB_DT>DISC_ATB_DT, ( interval#(Timestamp(LOAD_ATB_DT) - Timestamp(DISC_ATB_DT),'mm')),(interval#(Timestamp(LOAD_ATB_DT) - Timestamp(DISC_ATB_DT),'mm' ))) as Tight_Connection ,

Re: [Urgent]Scripting error

n1ef5ng1 — Wed, 15 May 2013 03:05:48 GMT

help~~~

Re: [Urgent]Scripting error

tresB — Wed, 15 May 2013 05:32:20 GMT

It seems that your if condition is not being used properly. you can simply use the following logic:

If(TIMESTAMP2> TIMESTAMP1,interval( TIMESTAMP2 - TIMESTAMP1, 'hh:mm'),interval(TIMESTAMP1-TIMESTAMP2, 'hh:mm')) as TimeDifference

Thanks.

topic Re: [Urgent]Scripting error in QlikView

[Urgent]Scripting error

Re: [Urgent]Scripting error

Re: [Urgent]Scripting error