sum is not working for interval function

ashmitp869 — Fri, 02 Dec 2022 04:24:21 GMT

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 :

Re: sum is not working for interval function

marcus_sommer — Fri, 02 Dec 2022 06:06:01 GMT

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

- Marcus