topic Re: Timestamp issues in App Development

Timestamp issues

Markbhai — Tue, 07 May 2024 23:36:56 GMT

Hi.

I have a timestamp field and I need to keep the time in the field but want to show it in a table with the 24 hour format (preferably without seconds)

The field is in the database as DD-MM-YY hh:mm:ss

In Data Manager I can show the date at DD/MM/YY HH:mm

In the load script (for some reason) the format shows as:

Timestamp(Timestamp#([occured_time], 'DD-MM-YYYY hh:mm:ss') ,'DD/MM/YYYY HH:mm') AS [occured_time],

In the Qlik Table it shows as a ?

What might I be doing wrong?

Very frustrating!!

Thanks

Mark

Re: Timestamp issues

Aasir — Wed, 08 May 2024 00:25:40 GMT

If you don't want seconds try fixing it in load script.
Timestamp(Timestamp#([occurred_time], 'DD-MM-YY hh:mm:ss') ,'DD/MM/YY HH:mm') AS [occurred_time]

Re: Timestamp issues

Markbhai — Wed, 08 May 2024 11:06:16 GMT

I am not sure about what is different between what you have said and what is already in the Load script. - But alt least what you are suggesting is what I am already doing which shows that I am not going mad 🙂

I guess the real question is then, what else could be causing the dashboard table to display a ?

Thanks

Mark.

Re: Timestamp issues

Markbhai — Wed, 08 May 2024 11:28:33 GMT

Fixed it.

Since I had been testing the format in the Data Manager the load script was generated automatically, so was in the auto generated section. (It wasnt working).

I moved the line

Timestamp(Timestamp#([occurred_time], 'DD-MM-YY hh:mm:ss') ,'DD/MM/YY HH:mm') AS [occurred_time]

to the main load script and after this it worked.

I feel there are some odd behaviours with the auto generated scripts - not sure if this is just me.

Thanks for your help.

Mark.

Re: Timestamp issues

BrunPierre — Wed, 08 May 2024 11:49:39 GMT

I found these useful a while back.

Dimension values are coming as " ? " (question mark) in sheets instead of number format

Multiple Question mark in list box