topic Re: Partial Accumulation in Graph in QlikView

Partial Accumulation in Graph

fred_s — Tue, 08 Nov 2011 10:54:53 GMT

Hi,

I guess it's just a small question:
For Stockmanagement I need to present current stock values and future stock values based on known changes. I know the current Stock values and the changes.

What I need is a graph with the current Stock value as startingpoint and the changes accumulated per week.

For example:
0. Current value = 20
1. 201146 (next week) = +10 (in)
2. 201147 (next week) = -5 (out)
3. 201148 (next week) = -14 (out)

The Graph for this example needs to have three Bars:
week 201146 - Stockvalue = 30 (20 + 10)
week 201147 - Stockvalue = 25 (30 - 5)
week 201148 - Stockvalue = 11 (25 - 14)

The problem is the need to accumulate the changes without accumulating the current value.

Anyone?
(example file attached)

Thanks in advance.

Re: Partial Accumulation in Graph

Tue, 08 Nov 2011 13:48:56 GMT

Hi,

See attached document. I added some sample previous data and a variable.

Succes!

Re: Partial Accumulation in Graph

Tue, 08 Nov 2011 14:08:21 GMT

He Fred,

may be my example is too simple, but it is worth a try.

Regards,Roland

Partial Accumulation in Graph

fred_s — Tue, 08 Nov 2011 14:54:53 GMT

Hi Roland and Halmar,

@Roland: Thanks for your response, but it is too simple indeed.
The current value (20) isn't a 'week-record', but actually the sum of some other field.

I've tried to translate my real problem in some bite-sized Qlikview example.
Maybe my example wasn't clear.

Thanks anyway 😉

* * *

@Halmar: Your values are correct but as mentioned to Roland, the current value isn't week 201145, but a formula on some other field. Maybe your solution can help me anyway. I will try to translate your suggestion back to my real problem.

Thanks.

Partial Accumulation in Graph

fred_s — Wed, 09 Nov 2011 12:47:06 GMT

@Halmar, your suggestion pointed me in the right direction.
I still have to fix some issues but I'm on the right track.

Thanks a lot.

Regards,
Fred