topic cumulative sum on Bar chart in QlikView

cumulative sum on Bar chart

dr_suresh_baabu — Wed, 08 Nov 2017 16:56:15 GMT

Hello,

I have a requirement to show up the cumulative sum on a Bar chart, There is no dimension in the chart and should be handled int the expression.

Also, the Cumulative sum should be used to calculate a metric (Cumulative sum/ Actual sum).

Note: The cumulative sum has to be calculated based on one column (Month_Year_Num from my Data)

I'm attaching the data and the QVW file explaining the requirement in detail.

Could you please take a look at it and share your thoughts in achieving this?

Thank you

sunny_talwar — Wed, 08 Nov 2017 17:17:10 GMT

May be these expressions for your first requirement:

=Sum(Aggr(RangeSum(Above(Sum({<Type={'Plan'}>} Data_Val), 0, RowNo())), Month_Year_Num))

Where do you intend to see the second req?

dr_suresh_baabu — Wed, 08 Nov 2017 18:00:40 GMT

Hello,

Thank you for the response.

I observed that the results does not comeup as expected when I make a selection on the Function Filter (please choose F5 from the filter above)

For the second requirement.

I need to perform 240/160 for Plan% and 720/580 for Actual in the example.

Also for resource function 'F5' it should be 20/20 for Plan and 220/110.

Thank you

sunny_talwar — Wed, 08 Nov 2017 19:01:12 GMT

Check this

dr_suresh_baabu — Thu, 09 Nov 2017 17:52:42 GMT

Thanks again. I believe this will meet the requirements.

I shall Implement this logic and let you know if I have any questions.