Difference between timestamps

[#1]

I am using the following as an expression to calculate the difference between timestamps, within a straight table

SUM(time(interval( [Delivered Time] - [Deliver By Time]),'h:mm:ss'))

If I try placing the exact same function within a variable and subsequently use the variable within the expression , I get incorrect results, Can anyone please explain why ?

Also is there a possibility to get negative results in case the Delivered Time is < Deliver By Time for the interval function ?

[MK_QSL]

Yes you can get negative values if EndTime is Lower than StartTime

Let us know how you are using this variable in expression...

[tresesco]

Working with variable is interesting. Probably you are missing an '=' symbol in variable declaration. If that is not the case, try to share your sample issue app.

[maxgro]

if you have 2 field I suppose you can use an expression like that

sum( [Delivered Time] - [Deliver By Time] )

and then format as an Interval (hh:mm:ss) in Number tab

[#5]

Thanks, I was using Interval(EndTime-StartTime)

I have now change that to Interval(StartTime-EndTime) and now I get -ve values

[#6]

Thanks, I was missing the formatting as interval in the Numbers Tab

[#7]

Im currently evaluating Qlikview, and have a personal edition , so Im not sure how I can share the app, especially the data within. For the variable I tried using the following inthe expression

=$(varName)

=varName

All rows display the same value, so it appears that whenusing variables , a specific start and end time is being considered and not individual start and end times. Looks like some aggregation is being used

[tresesco]

If you have personal edition, that doesn't stop people access your app with licensed edition. See : Preparing examples for Upload - Reduction and D... | Qlik Community