Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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';
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
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...