Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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