Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Site Visits during a Time Period?

Hi!

I have two database tables:  one that holds visits to websites and another which contains a schedule of classes.   I need to join the two tables so I can track the websites visited during a class period.  

The website visits table has a time field for when the student visited the site.  The Schedule table has a start and end time for each class period.  

Any ideas on how I can accomplish this? 

Tags (2)
1 Reply
kuczynska
Contributor III

Re: Site Visits during a Time Period?

Hi,

You should probably consider using intervalmatch() to associate times from website tables and start/end times of class.

Have a look here - this pdf explains very well on how this could be done in QV; don't see a reason why this wouldn't work in Sense.

intevalMatch.pdf

BTW - there is a good Help article also in Sense on intervalmatch function use in the load script.

Community Browser