Qlik Community

App Development

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

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
c_latham
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!

0 Replies