Accumulated chart

[PaulaRibeiro]

Hi,

I have some difficulties for calculating the accumulated sum.  I have a line chart where I calculates the sum of the values since the beginning of the year.

I use the function RangeSum() and Above() and the line of values when I don't have any year selected is correct.

My issue is when I select one year, the values doesn't accumulate.

Any ideia to resolve that?

Best Regards

[sunny_talwar]

Where is the image?

[Masi_Sahargahi]

HI ,

I have attached a document using cumulative sum,I hope it helps.

[PaulaRibeiro]

I have one year selected

[sunny_talwar · Accepted solution]

Can you make sure that you have checked 'Suppress Zero Values' on the presentation tab of the chart properties?

[PaulaRibeiro]

That's what was missing. Thank you for the help!

[sunny_talwar]

No problem. Please close the thread down by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny