topic function hour behaviour on 0.00 slot in App Development

function hour behaviour on 0.00 slot

AFurlati — Mon, 17 Oct 2022 08:38:46 GMT

i don't understand why using the "hour" funcion, on a "date and time" field it shows in the istogram the 0.00 -1.00 slot in the previuous date

I.e:

I have 10 records of voyager trips from 0.00 to 1.00 on 06/05/2022

and Qlik shows those trips in 05/06/2022

P.S Please note that my date fields are in format unix translated

Can you help?

Re: function hour behaviour on 0.00 slot

vinieme12 — Mon, 17 Oct 2022 09:01:15 GMT

1) can you post a sample value from your timestamp field ?

2) also check what is the below variable set to

SET TimestampFormat='YYYY-MM-DD h:mm:ss[.fff] TT';

Re: function hour behaviour on 0.00 slot

AFurlati — Mon, 17 Oct 2022 09:25:37 GMT

1) OK

I 've used this formula to transpose

ConvertToLocalTime(Date(25569 + ([checkin_time] / 86400)), 'Rome') AS [CIN-time]

checkin_time is for instance the first timestamp: 1605673561

2) Do you suggest to use this expression instead of the one i quoted?

But it seem to me is a problem of the function hour, because all the data are correclty exported in a table report, while if I try to make an instogram with the slot by hours ONLY for the 0.00-1.00 slots it changes the date

Re: function hour behaviour on 0.00 slot

AFurlati — Mon, 17 Oct 2022 09:58:58 GMT

the format is for instance: 1605673561

but i used this formula to transpose: ConvertToLocalTime(Date(25569 + ([checkin_time] / 86400)), 'Rome') AS [CIN-time],

But i think there is a problem in the hour function, because if a meke a table report of the data, the fields are correct...