topic Dooms Day Calculator in QlikView https://community.qlik.com/t5/QlikView/Dooms-Day-Calculator/m-p/822783#M290025 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I am new to QlikView (surprise) and have a challenge I hope you can help me overcome.&nbsp; </P><P></P><P>The report I have tracks the time each day a server completes its restore.&nbsp; We have a metric of 9:00am that all servers have to be online after backing up.&nbsp;&nbsp; I have added a trend line that shows it will intercept the 9:00am reference line sometime in the future.&nbsp; I want a text box that acts as a ‘Dooms Day Calculator’.&nbsp; 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.&nbsp; 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.</P><P></P><P>Here is a .qvw file that loads some example data and shows a bit about what I am trying to display.</P><P></P><P>Thanks,<BR />Chip</P></BODY></HTML> Tue, 20 Jan 2015 20:05:37 GMT 2015-01-20T20:05:37Z Dooms Day Calculator https://community.qlik.com/t5/QlikView/Dooms-Day-Calculator/m-p/822783#M290025 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I am new to QlikView (surprise) and have a challenge I hope you can help me overcome.&nbsp; </P><P></P><P>The report I have tracks the time each day a server completes its restore.&nbsp; We have a metric of 9:00am that all servers have to be online after backing up.&nbsp;&nbsp; I have added a trend line that shows it will intercept the 9:00am reference line sometime in the future.&nbsp; I want a text box that acts as a ‘Dooms Day Calculator’.&nbsp; 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.&nbsp; 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.</P><P></P><P>Here is a .qvw file that loads some example data and shows a bit about what I am trying to display.</P><P></P><P>Thanks,<BR />Chip</P></BODY></HTML> Tue, 20 Jan 2015 20:05:37 GMT https://community.qlik.com/t5/QlikView/Dooms-Day-Calculator/m-p/822783#M290025 2015-01-20T20:05:37Z