Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have two table
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
This how my chart looks like...
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.
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
have a look at the attach example
Thank you Sunny. It worked.
Worked like magic. Thank you, Sunny. Your comments have always been helpful.