topic Forecast Trend with MTD totally each month in App Development https://community.qlik.com/t5/App-Development/Forecast-Trend-with-MTD-totally-each-month/m-p/1085742#M18049 <HTML><HEAD></HEAD><BODY><P>We have a forecast field that has a total for each month.&nbsp; For the year total 13mil.&nbsp; We have a line chart and instead showing just the total for each month we want the total up to that month.&nbsp; So for January I show total January, for February we show total for January and February, and so forth to December where December will be 13mil.&nbsp; So the line chart will be a straight line trend for forecast.&nbsp; I will then add actuals to compare the two lines against.</P></BODY></HTML> Thu, 03 Mar 2016 16:16:16 GMT Anonymous 2016-03-03T16:16:16Z Forecast Trend with MTD totally each month https://community.qlik.com/t5/App-Development/Forecast-Trend-with-MTD-totally-each-month/m-p/1085742#M18049 <HTML><HEAD></HEAD><BODY><P>We have a forecast field that has a total for each month.&nbsp; For the year total 13mil.&nbsp; We have a line chart and instead showing just the total for each month we want the total up to that month.&nbsp; So for January I show total January, for February we show total for January and February, and so forth to December where December will be 13mil.&nbsp; So the line chart will be a straight line trend for forecast.&nbsp; I will then add actuals to compare the two lines against.</P></BODY></HTML> Thu, 03 Mar 2016 16:16:16 GMT https://community.qlik.com/t5/App-Development/Forecast-Trend-with-MTD-totally-each-month/m-p/1085742#M18049 Anonymous 2016-03-03T16:16:16Z Re: Forecast Trend with MTD totally each month https://community.qlik.com/t5/App-Development/Forecast-Trend-with-MTD-totally-each-month/m-p/1085743#M18050 <HTML><HEAD></HEAD><BODY><P>Does anyone have knowledge on how to do a linear line chart.&nbsp; We need a chart that has budgets trending up so for let's say March it would January + March and so forth.&nbsp; Is there an expression that can do that.</P></BODY></HTML> Mon, 14 Mar 2016 14:50:16 GMT https://community.qlik.com/t5/App-Development/Forecast-Trend-with-MTD-totally-each-month/m-p/1085743#M18050 Anonymous 2016-03-14T14:50:16Z