Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The hours aren't a real date/timestamp value anymore else an integer - therefore, I suggest changing the format-patter to an integer.
- Marcus
The hours aren't a real date/timestamp value anymore else an integer - therefore, I suggest changing the format-patter to an integer.
- Marcus