Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Indirect Set Analysis

Hi All,

Not sure if Indirect Set Analysis is what I need but maybe it is!

I have a moves table, which details all moves and a visit that those moves are associated to. hen I have a Visit table which details information on the visit itself. If I select a visit I can see all of those associated moves no problem.

However, what I am trying to find is all moves that occurred in the time between minimum move time and maximum move time when a visit is selected (not just those directly associated).

So Visit 1 could have had 5 moves directly associated (14/07/2020 00:00, 14/07/2020 00:05, 14/07/2020 00:07, 14/07/2020 00:11, 14/07/2020 00:13). But between 14/07/2020 00:00 and 14/07/2020 00:13 there may have been a total of 10 moves (5 associated to visit 1 and 5 associated to other visits).

What would be the best process for this?

I tired something along these lines but without any luck:

Sum({$<[Move Kind]=P({1<[Time of Put]={">Min([Time of Put])<Max([Time of Put])"}>}[Move Kind])>}[Move Counter])

Thanks!

Tags (2)
Labels (1)