Discussion board where members can learn more about Qlik Sense App Development and Usage.
Need help to calculate next 11 cumulative sum. I did not want to use the rangesum below since it is restricted to the dimension value in chart.
EG: if Apr 17 then it shld be from Apr 17 to Feb 18.
Need solution at the back end. I have already used the as of table but it works with rolling last month.
If you select Apr 17 - How you are getting data in script? BTW, You are seeing those affections in design. Why are you looking in script.
Hw u will do it at front end. I need the 13 months in the chart and for each month it shld calculate its respective next 11 month sales.
If Jan-18 selected, What is the expected result? And How much data you have for forecast, if any?