Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
vadim_grab
Contributor

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
Valued Contributor III

Re: Interval Match vs Timestamp

hello

could you explain a little bit more your need ?

vadim_grab
Contributor

Re: Interval Match vs Timestamp

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
Valued Contributor III

Re: Interval Match vs Timestamp

i think you can use intervalmatch()

look at qlik documentation

"Matching intervals to discrete data"

it seems to be your need

vadim_grab
Contributor

Re: Interval Match vs Timestamp

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

MVP & Luminary
MVP & Luminary

Re: Interval Match vs Timestamp

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
Contributor

Re: Interval Match vs Timestamp

Your are right!

Thanks, Markus