Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

escarber
New Contributor

Forecast Trend with MTD totally each month

We have a forecast field that has a total for each month.  For the year total 13mil.  We have a line chart and instead showing just the total for each month we want the total up to that month.  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.  So the line chart will be a straight line trend for forecast.  I will then add actuals to compare the two lines against.

1 Reply
escarber
New Contributor

Re: Forecast Trend with MTD totally each month

Does anyone have knowledge on how to do a linear line chart.  We need a chart that has budgets trending up so for let's say March it would January + March and so forth.  Is there an expression that can do that.