Qlik Community

App Development

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

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qs123
Contributor II
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

Labels (5)
1 Solution

Accepted Solutions
sunny_talwar

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())))

View solution in original post

4 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

have a look at the attach example 

sunny_talwar

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())))
qs123
Contributor II
Contributor II
Author

Thank you Sunny. It worked.

rafsan
Contributor II
Contributor II

Worked like magic. Thank you, Sunny. Your comments have always been helpful.