Interval Match vs Timestamp

[vadim_grab]

Hi, All!

Can any one help me with linked timestamp date and timestamp interval using  interval match function?

Is it possible? Or may be I trying to do something impossible?

Many thanks for any help!

Vadim

[olivierrobin]

hello

could you explain a little bit more your need ?

[vadim_grab]

Hi, Robin

I need to link sales transactions with some events  wich have start and end time.

One important point - events can have a beginning and an end time in different days.

Example: sale time 22.05.2018 23:30, event start time  22.05.2018 23:00 and end time 23.05.2018 1:00.

Thanks a lot!

Vadim

[olivierrobin]

i think you can use intervalmatch()

look at qlik documentation

"Matching intervals to discrete data"

it seems to be your need

[vadim_grab]

I'm afraid this is not what I'm looking for.

Separately matching time or date and their intervals  not difficult.

Most pain:

1- date&time together

2  - time transaction and events time intervals there dates differents

Vadim

[marcus_sommer]

Dates, times and timestamps are just numbers and therefore an intervalmatch will work. An appropriate rounding like:

floor(timestamp, 1/24/60)

will be useful to avoid the risk of potential rounding errors.

- Marcus

[vadim_grab]

Your are right!

Thanks, Markus