Skip to main content

App Development

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

Announcements
JAN. 24, Q&A with Qlik: Making the Move to Qlik Cloud Reporting: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mikeslade
Contributor III
Contributor III

Identify Idle or available reload times?

Hello, looking for some guidance on reporting of reload tasks.

In reload monitor, I can see start and end time of all reload tasks, but I want to have a view of periods of time when there is no reload activity happening.

Essentially when a reload task finishes and there are no other tasks running, then that would be inactivity start time and then when the next task begins, the inactivity period would get an end time.

I've got views built to show next execution times, but this only works for the first reload task in the chain as the others are triggered on completion I haven't quite got the view I'd like to help understand what the reload profile looks like.

I've been struggling to figure this out and suspect I might need to do something in the load script and wondered whether anyone has managed something similar or has any pointers?

Thanks!

Labels (1)
1 Reply
Dalton_Ruer
Support
Support

I'm thinking you can create a master calendar of every minute of every day. And use IntervalMatch to map all of the times for reloads and then you can look for those minutes of each day with no reload tasks.