Timestamp issue QV 12.20 september 2017
Article Number: 000043972 | Last Modified: 2019/05/25
When exporting timestamp data to Excel from QlikView or Qlik Sense, we may get prompted error message from Excel.
In Excel, milliseconds are normally expressed as seconds and tenths ("s.0"), seconds and hundreds ("s.00"), second and thousands ("s.000") and this is somewhat different from our fraction (“s.f”), (“s.ff”) and (“s.fff”) that does not automatically translate into its Excel counterpart. In order to correctly export and interpret milliseconds from QlikView / QlikSense to Excel, a custom format that requires correct decimal separator as defined by locale (in my case: ",") must be established in Excel. In my case, the correct custom format (with my locale) would be: “mm:ss,000” since my locale (Swedish) use comma as decimal separator
Note: Our internal fraction (“.fff”) is compatible with some databases and programmatic millisecond formats, but unfortunately not with Exce
Check the format of the Timestamp field , it need to be changed from DD.MM.YYYY h:mm:ss[.fff] either
DD.MM.YYYY h:mm:ss.fff or