Load the Milli Seconds (full timestamp value) from DB

[#1]

Hi Folks, We have a event table and all the events was stored into DB table with Time stamp (included Milli Seconds).

I load the data and I didn't see any Milli seconds on Qlikview.

Please help me how can I load the milli seconds from DB and show on Qlikview charts.

[Gysbert_Wassenaar · Accepted solution]

The milliseconds are probably loaded, just not displayed. If you specify a timestamp format like DD/MM/YYYY hh:mm:ss.fff you should see the milliseconds as the fff part. Try adding the timestamp field to a listbox or table box and on the Number tab of the properties window of the object check the option Override Document Settings, choose timestamp and adjust the Format Pattern to your liking.