function hour behaviour on 0.00 slot

[AFurlati]

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?

[vinieme12]

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';

[AFurlati]

 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

[AFurlati]

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...