Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
Timestamp issue QV 12.20 september 2017
Article Number: 000043972 | Last Modified: 2019/05/25Description
When exporting timestamp data to Excel from QlikView or Qlik Sense, we may get prompted error message from Excel.
Cause
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
Refer QLIK-83478.
Note: Our internal fraction (“.fff”) is compatible with some databases and programmatic millisecond formats, but unfortunately not with Exce
Refer QLIK-83478.
Resolution
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
DD.MM.YYYY h:mm:ss.000
DD.MM.YYYY h:mm:ss.fff or
DD.MM.YYYY h:mm:ss.000
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us