topic Timestamp key not working in QlikView

Timestamp key not working

alexandermllr — Fri, 15 Nov 2024 23:39:17 GMT

Hello everyone,

I have two tables which are conneced by a timestamp key. Sometimes the data are not conneced and it will greate a second line in the table. The format in both tabels are the same.

Example:

Timestamp_Key	Data Table 1	Data Table 2
01.01.2020 00:30	25	-
01.01.2020 00:30	-	50

I hope someone can help me!

Thanks!

Re: Timestamp key not working

QFabian — Tue, 10 Nov 2020 14:30:47 GMT

Hi, maybe the timestamps looks alike, but can have minimal differences in milliseconds.

try apply ceil() or floor() to have the same numbers of decimals for each timestamp.

Re: Timestamp key not working

alexandermllr — Tue, 10 Nov 2020 15:46:59 GMT

Hi,

thank you, but I did not work.

I just used round(Timestamp_Key,0.01) and now it works.