topic Cummulation with divisions dont give needed numbers. in QlikView

Cummulation with divisions dont give needed numbers.

retko1985 — Wed, 23 Aug 2017 14:13:39 GMT

Hello,

here is an example.

I am, doing accumulation with day dimension. So on first day I have this from expression: 5000 / 5 = 1000. On second day I have this 6000/1 = 6000 .

What I get in chart is this (when I have full accumulation checked and both days selected) - last second day is showing 7000 like this (5000/5)+(6000/1) = 7000

This is not what I want. I want this: (5000+6000) / (5+1) = 11000 / 6 = 1833.33.

Can someone help me here? How can I achieve this?

Thank you.

Here is a QVW with example.

Re: Cummulation with divisions dont give needed numbers.

sunny_talwar — Wed, 23 Aug 2017 14:22:05 GMT

May be do like this

RangeSum(Above(Numerator, 0, RowNo()))/RangeSum(Above(Denominator, 0, RowNo()))

Re: Cummulation with divisions dont give needed numbers.

sunny_talwar — Wed, 23 Aug 2017 14:24:14 GMT

Try this

=RangeSum(Above(Sum(Sales), 0, RowNo()))/RangeSum(Above(Sum(Registrations), 0, RowNo()))

Re: Cummulation with divisions dont give needed numbers.

retko1985 — Thu, 24 Aug 2017 12:52:01 GMT

Hello,

this work great. Thank you. There is just one visual thing, maybe you can help me with. As I have whole month days on x axes, when I select for example day 15, on X axes I would have bars hor days 15,16,17 and so on. Is this the property of this expression? Because When I select day 15, I would expect only 1 bar for day 15.

Please help. Thank you.

Re: Cummulation with divisions dont give needed numbers.

sunny_talwar — Thu, 24 Aug 2017 12:57:01 GMT

You want to see only one bar? It should be doing that today, unless you have set analysis in your expression? May be try this

=RangeSum(Above(Sum({<Day>}Sales), 0, RowNo()))/RangeSum(Above(Sum({<Day>}Registrations), 0, RowNo())) * Avg(1)