Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

Next 11 months cumulative sum

Hi All,

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.

Regards

3 Replies

Re: Next 11 months cumulative sum

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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: Next 11 months cumulative sum

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. 

Re: Next 11 months cumulative sum

If Jan-18 selected, What is the expected result? And How much data you have for forecast, if any?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)