Hello Everyone,
I am new to QlikView (surprise) and have a challenge I hope you can help me overcome.
The report I have tracks the time each day a server completes its restore. We have a metric of 9:00am that all servers have to be online after backing up. I have added a trend line that shows it will intercept the 9:00am reference line sometime in the future. I want a text box that acts as a ‘Dooms Day Calculator’. Each day it refreshes, it will perform the calculation (linest_m I think?) and display what ‘Day’ the restore will take longer than 9:00am. So our network guys have a visual as well as a countdown that tells them when they will be out of compliance unless they improve performance.
Here is a .qvw file that loads some example data and shows a bit about what I am trying to display.
Thanks,
Chip