topic Burndown with forecast in QlikView https://community.qlik.com/t5/QlikView/Burndown-with-forecast/m-p/520878#M194579 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm looking for a way to get a burndown of our project budgets ... and also forecasting a trendline.</P><P></P><P>e.g.</P><P>I have a project X, with the budget of 720.000 ... the budget has an end-date (e.g. apr-2014) ... </P><P></P><P>sample costs:</P><TABLE><TBODY><TR><TD>month-year</TD><TD>amount</TD></TR><TR><TD>Jul-2013</TD><TD>438</TD></TR><TR><TD>Aug-2013</TD><TD>2536,06</TD></TR><TR><TD>Sep-2013</TD><TD>2611,5</TD></TR><TR><TD>Oct-2013</TD><TD>26120,99</TD></TR><TR><TD>Nov-2013</TD><TD>50802,58</TD></TR></TBODY></TABLE><P></P><TABLE><TBODY><TR><TD>week-year</TD><TD>amount</TD></TR><TR><TD>31-2013</TD><TD>1132</TD></TR><TR><TD>32-2013</TD><TD>1212,32</TD></TR><TR><TD>33-2013</TD><TD>410,74</TD></TR><TR><TD>35-2013</TD><TD>219</TD></TR><TR><TD>36-2013</TD><TD>786,5</TD></TR><TR><TD>39-2013</TD><TD>1825</TD></TR><TR><TD>40-2013</TD><TD>219</TD></TR><TR><TD>41-2013</TD><TD>2190</TD></TR><TR><TD>42-2013</TD><TD>4993</TD></TR><TR><TD>43-2013</TD><TD>9667,35</TD></TR><TR><TD>44-2013</TD><TD>12132,3</TD></TR><TR><TD>45-2013</TD><TD>14886,36</TD></TR><TR><TD>46-2013</TD><TD>9562,64</TD></TR><TR><TD>47-2013</TD><TD>16937,92</TD></TR><TR><TD>48-2013</TD><TD>6335</TD></TR></TBODY></TABLE><P></P><P></P><P>I'm looking for a burndownline (budget-costs), but also the forecast (as an expression) ... </P><P>Is there a way to show the enddate of the budget as a colored vertical line?</P><P>Is it also possible to show the date where the budget is burned down to 0 (e.g. in the forecast)</P><P></P><P>The dimension is a cyclic group of month-year and week-year ... </P><P></P><P></P><P></P><P>rgrds,</P><P></P><P>Anita</P></BODY></HTML> Tue, 03 Dec 2013 11:41:43 GMT Anonymous 2013-12-03T11:41:43Z Burndown with forecast https://community.qlik.com/t5/QlikView/Burndown-with-forecast/m-p/520878#M194579 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm looking for a way to get a burndown of our project budgets ... and also forecasting a trendline.</P><P></P><P>e.g.</P><P>I have a project X, with the budget of 720.000 ... the budget has an end-date (e.g. apr-2014) ... </P><P></P><P>sample costs:</P><TABLE><TBODY><TR><TD>month-year</TD><TD>amount</TD></TR><TR><TD>Jul-2013</TD><TD>438</TD></TR><TR><TD>Aug-2013</TD><TD>2536,06</TD></TR><TR><TD>Sep-2013</TD><TD>2611,5</TD></TR><TR><TD>Oct-2013</TD><TD>26120,99</TD></TR><TR><TD>Nov-2013</TD><TD>50802,58</TD></TR></TBODY></TABLE><P></P><TABLE><TBODY><TR><TD>week-year</TD><TD>amount</TD></TR><TR><TD>31-2013</TD><TD>1132</TD></TR><TR><TD>32-2013</TD><TD>1212,32</TD></TR><TR><TD>33-2013</TD><TD>410,74</TD></TR><TR><TD>35-2013</TD><TD>219</TD></TR><TR><TD>36-2013</TD><TD>786,5</TD></TR><TR><TD>39-2013</TD><TD>1825</TD></TR><TR><TD>40-2013</TD><TD>219</TD></TR><TR><TD>41-2013</TD><TD>2190</TD></TR><TR><TD>42-2013</TD><TD>4993</TD></TR><TR><TD>43-2013</TD><TD>9667,35</TD></TR><TR><TD>44-2013</TD><TD>12132,3</TD></TR><TR><TD>45-2013</TD><TD>14886,36</TD></TR><TR><TD>46-2013</TD><TD>9562,64</TD></TR><TR><TD>47-2013</TD><TD>16937,92</TD></TR><TR><TD>48-2013</TD><TD>6335</TD></TR></TBODY></TABLE><P></P><P></P><P>I'm looking for a burndownline (budget-costs), but also the forecast (as an expression) ... </P><P>Is there a way to show the enddate of the budget as a colored vertical line?</P><P>Is it also possible to show the date where the budget is burned down to 0 (e.g. in the forecast)</P><P></P><P>The dimension is a cyclic group of month-year and week-year ... </P><P></P><P></P><P></P><P>rgrds,</P><P></P><P>Anita</P></BODY></HTML> Tue, 03 Dec 2013 11:41:43 GMT https://community.qlik.com/t5/QlikView/Burndown-with-forecast/m-p/520878#M194579 Anonymous 2013-12-03T11:41:43Z