Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vadim_grab
Creator
Creator

Interval Match vs Timestamp

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

6 Replies
olivierrobin
Specialist III
Specialist III

hello

could you explain a little bit more your need ?

vadim_grab
Creator
Creator
Author

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
Specialist III
Specialist III

i think you can use intervalmatch()

look at qlik documentation

"Matching intervals to discrete data"

it seems to be your need

vadim_grab
Creator
Creator
Author

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
Creator
Creator
Author

Your are right!

Thanks, Markus