Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

angeloguidi
New Contributor II

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

Re: Chart accumulation last 5 values but consider alla values

Can you please share the sample qvw ?

Re: Chart accumulation last 5 values but consider alla values

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

Re: Chart accumulation last 5 values but consider alla values

What is your chart expression?

angeloguidi
New Contributor II

Re: Chart accumulation last 5 values but consider alla values

Here the ezample.

Bye Angelo

Re: Chart accumulation last 5 values but consider alla values

Expression:

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

Capture.PNG

angeloguidi
New Contributor II

Re: Chart accumulation last 5 values but consider alla values

Thanks you saved me !!!

Bye Angelo

Community Browser