topic Predictive Forecasting? in QlikView https://community.qlik.com/t5/QlikView/Predictive-Forecasting/m-p/679361#M475582 <HTML><HEAD></HEAD><BODY><P>I am working with a development group looking to release software versions.&nbsp; They track the number of bugs, and how many are and closed but what they want me to do is to provide them the ability to put in a date and determine if the bugs will be resolved by that time.</P><P></P><P>I have a graph which shows open vs. closed bugs and have applied the trendline and can forecast based on the trendline into the future (however many weeks I specify), but how do I ask if it will be done by a given date?</P><P></P><P>Is there some way I can calculate the date they enter as X weeks into the future and then modify the chart to set the forecast number of weeks to that calculated value?</P><P></P><P>Or, conversely, is the forecast formula available so that I can calculate how many weeks it will be until we get the number of open bugs down to a specified number?</P><P></P><P>Thank you.</P></BODY></HTML> Tue, 15 Jul 2014 16:42:14 GMT 2014-07-15T16:42:14Z Predictive Forecasting? https://community.qlik.com/t5/QlikView/Predictive-Forecasting/m-p/679361#M475582 <HTML><HEAD></HEAD><BODY><P>I am working with a development group looking to release software versions.&nbsp; They track the number of bugs, and how many are and closed but what they want me to do is to provide them the ability to put in a date and determine if the bugs will be resolved by that time.</P><P></P><P>I have a graph which shows open vs. closed bugs and have applied the trendline and can forecast based on the trendline into the future (however many weeks I specify), but how do I ask if it will be done by a given date?</P><P></P><P>Is there some way I can calculate the date they enter as X weeks into the future and then modify the chart to set the forecast number of weeks to that calculated value?</P><P></P><P>Or, conversely, is the forecast formula available so that I can calculate how many weeks it will be until we get the number of open bugs down to a specified number?</P><P></P><P>Thank you.</P></BODY></HTML> Tue, 15 Jul 2014 16:42:14 GMT https://community.qlik.com/t5/QlikView/Predictive-Forecasting/m-p/679361#M475582 2014-07-15T16:42:14Z