Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
See attached document. I added some sample previous data and a variable.
Succes!
Hi,
See attached document. I added some sample previous data and a variable.
Succes!
He Fred,
may be my example is too simple, but it is worth a try.
Regards,Roland
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.
@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