Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Search results than a query I get a list of events and hours , a Member which have, I wonder if anyone knows how to calculate Time Total acuumulate time in minutes, based on a schedule, for example from 13:00 to 15:00 not count. In this case the total would be 59 minutes. Thank you very much for the help.
03/03/2020 12:49 | |
03/03/2020 12:53 | 4 |
03/03/2020 18:49 | |
03/03/2020 18:52 | 3 |
03/03/2020 18:55 | 3 |
03/03/2020 19:06 | 11 |
03/03/2020 19:15 | 9 |
03/03/2020 19:25 | 10 |
03/03/2020 19:30 | 5 |
03.04.2020 8:02 | |
04.03.2020 8:10 | 8 |
04.03.2020 8:15 | 6 |
You would likely need to use set analysis for this and you may need to use AGGR too, here are a couple of Design Blog posts that may be helpful to get you on the right track there.
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
Hopefully this may get you on the right track, but you likely need to provide some further details on things to get further responses, as I was not quite sure of exactly what it is you are actually wanting to do, so apologies if I have missed the mark completely.
Regards,
Brett