Discussion Board for collaboration related to QlikView App Development.
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!
could you explain a little bit more your need ?
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!
i think you can use intervalmatch()
look at qlik documentation
"Matching intervals to discrete data"
it seems to be your need
I'm afraid this is not what I'm looking for.
Separately matching time or date and their intervals not difficult.
1- date&time together
2 - time transaction and events time intervals there dates differents
Dates, times and timestamps are just numbers and therefore an intervalmatch will work. An appropriate rounding like:
will be useful to avoid the risk of potential rounding errors.
Your are right!