Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Fernando2000
Contributor
Contributor

accumulation of time

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:534
03/03/2020 18:49 
03/03/2020 18:523
03/03/2020 18:553
03/03/2020 19:0611
03/03/2020 19:159
03/03/2020 19:2510
03/03/2020 19:305
03.04.2020 8:02 
04.03.2020 8:108
04.03.2020 8:156
Labels (1)
1 Reply
Brett_Bleess
Employee
Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.