topic Re: Interval Match vs Timestamp in QlikView

Interval Match vs Timestamp

vadim_grab — Thu, 05 Jul 2018 07:11:01 GMT

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 — Thu, 05 Jul 2018 07:31:57 GMT

hello

could you explain a little bit more your need ?

vadim_grab — Thu, 05 Jul 2018 07:45:31 GMT

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 — Thu, 05 Jul 2018 08:00:21 GMT

i think you can use intervalmatch()

look at qlik documentation

"Matching intervals to discrete data"

it seems to be your need

vadim_grab — Thu, 05 Jul 2018 08:22:59 GMT

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 — Thu, 05 Jul 2018 11:22:33 GMT

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 — Fri, 06 Jul 2018 13:02:39 GMT

Your are right!

Thanks, Markus