Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Chart accumulation last 5 values but consider alla values

Dear Experts,


I’ve a problem with a chart, in the attached picture I try to show my question.

In the chart I’ve in the X axis there are weeks from the begin of the year and in the Y axis there are some values that I want to show “accumulate”.

I’cant show only the 10 or 8 last values but I want to have consider all the values from the begin of the year.


Thanks in advance


Bye Angelo


P.S. I have attached the picture I have and the picture I want.

6 Replies
Not applicable
Author

Can you please share the sample qvw ?

settu_periasamy
Master III
Master III

How you are getting your accumulated value?

If it's derived from Script, you can use the 'Dimension Limit' for Top 10 or 8 values

sunny_talwar

What is your chart expression?

Anonymous
Not applicable
Author

Here the ezample.

Bye Angelo

sunny_talwar

Expression:

RangeSum(Above(Sum({<AA>}BB), 0, RowNo())) * Avg(1)

Capture.PNG

Anonymous
Not applicable
Author

Thanks you saved me !!!

Bye Angelo