topic Re: Bar chart FULL accumulation question in QlikView

Bar chart FULL accumulation question

danialier — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a question that I hope someone can help.

I have the attached QV with two bar graphs showing the revenue evolution from January to March. First graph is showing revenues with NO Accumulation. Second graph is showing revenues with FULL Accumulation.

Data is showed as follows:

> Graph with NO Accumulation: January 3 usd / February 5 usd / March 4 usd

> Graph with FULL Accumulation: January 3 usd / February 8 usd (3+5) / March 12 usd (3+5+4)

The issue is: when I select February + March months from the List box, the bar chart with FULL Accumulation shows the following data

> February 5 usd / March 9 usd (5+4)

And actually what I'd expect is a graph showing:

> February 8 usd (3+5) / March 12 usd (3+5+4)

Can anyone help on that topic?

BR,

Dani

Re: Bar chart FULL accumulation question

MK_QSL — Wed, 04 Apr 2018 10:13:56 GMT

For the 2nd Chart

Expression tab

Tick No Accumulation

Now use below expression to get the accumulation using Expression

RangeSum(Above(Sum({<Period>}Amount),0,RowNo())) * Avg(1)

Re: Bar chart FULL accumulation question

thevingo — Wed, 04 Apr 2018 10:17:48 GMT

have you tried this

But I think as a good practice, you should try to do this as SET expression using Min & Max date ranges