Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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