topic Re: Chart accumulation last 5 values but consider alla values in QlikView

Chart accumulation last 5 values but consider alla values

Anonymous — Tue, 12 Apr 2016 08:58:14 GMT

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.

Tue, 12 Apr 2016 14:22:57 GMT

Can you please share the sample qvw ?

settu_periasamy — Tue, 12 Apr 2016 14:37:12 GMT

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 — Tue, 12 Apr 2016 14:39:15 GMT

What is your chart expression?

Anonymous — Tue, 12 Apr 2016 15:19:01 GMT

Here the ezample.

Bye Angelo

sunny_talwar — Tue, 12 Apr 2016 16:26:13 GMT

Expression:

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

Anonymous — Tue, 12 Apr 2016 17:19:50 GMT

Thanks you saved me !!!

Bye Angelo