Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

fred_s
Contributor III

Partial Accumulation in Graph

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.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Partial Accumulation in Graph

Hi,

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

Succes!

4 Replies
Not applicable

Re: Partial Accumulation in Graph

Hi,

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

Succes!

Not applicable

Re: Partial Accumulation in Graph

He Fred,

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

Regards,Roland

fred_s
Contributor III

Partial Accumulation in Graph

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.


fred_s
Contributor III

Partial Accumulation in Graph

@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

Community Browser