Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
qs123
New Contributor II

How to stop future month prediction in Cumulative sum?

Hi Guys,

I have two table

  1. Showing Actual Revenue from Jan 2019 to Sep 2019
  2. Showing Predicted Revenue from Jan 2019 to Dec 2019

I am trying to create cumulative bar chart to show how much we were suppose to earn and how much we have actually earned and how much more to achieve?

I am using following expressions

  • For Cumulative Revenue  = rangesum( above( sum(Revenue),0,rowno()))
  • For Cumulative Target  =  rangesum( above( sum(Target),0,rowno()))

This how my chart looks like...

bar.png

Here is the problem is...

I do not have Revenue data for (Oct, Nov & Dec) Still the chart is projecting those value. How do I stop it doing so?

 

Please refer to the attached  sample QVF application and Sample Data.

Thank you

3 Replies
Highlighted
Partner
Partner

Re: How to stop future month prediction in Cumulative sum?

hi 

have a look at the attach example 

Highlighted

Re: How to stop future month prediction in Cumulative sum?

You can also try like this... but this might become a problem if you happen to have a month without Revenue in your actual data

If(Sum(Revenue) <> 0, RangeSum(Above(Sum(Revenue), 0, RowNo())))
Highlighted
qs123
New Contributor II

Re: How to stop future month prediction in Cumulative sum?

Thank you Sunny. It worked.