topic Visualization Date Time in Straight Table in App Development

Visualization Date Time in Straight Table

fachto76 — Tue, 22 Apr 2025 17:08:47 GMT

Hi All,

I have a weird issue.

I created a spreadsheet which contains the date and the hour

I load into Qlik and display in a straight table & for some reason 59 min 59 sec are added.
For several hundred rows it is showing the data as the excel, but then it started adding these additional minutes and seconds.

Current Version is Qlik On Prem November 2024 SR7

Re: Visualization Date Time in Straight Table

Or — Tue, 22 Apr 2025 17:33:58 GMT

What makes you think it's the table? Did you check the underlying data (e.g. by using the Search option on this field)? Is there any manipulation done to the field when it's loaded or displayed? Is the data actually as displayed in Excel or is Excel's display setting overriding data that includes a timestamp with more details?

Re: Visualization Date Time in Straight Table

David_Friend — Tue, 22 Apr 2025 17:49:06 GMT

maybe put the date and time in different columns in Excel