sum is not working for interval function

[ashmitp869]

Hi there,

I have a field ED Hours which is the date diff of Departure and Arrival calculating in hours .

So I used -

Interval([Departure DateTime] - [Arrival DateTime], 'h')as [ED_LOS_HOURS]

in qlikview script.

The requirement is when exporting the file in excel the sum is not calculating correctly , everything is fine in qlikview.

Is there any way to calculate the sum when export to excel. ?

even I change the measure total model -

Change format

After export to excel :

@marcus_sommer please assist

[marcus_sommer · Accepted solution]

The hours aren't a real date/timestamp value anymore else an integer - therefore, I suggest changing the format-patter to an integer.

- Marcus