Discussion Board for collaboration related to Creating Analytics for QlikView.
Firstly sorry if something has already been asked and answered - I couldn't find.. Shall be glad if someone gives a link.
What my problem is:
I have -
1. a number of materials
2. consumption figures for them in future
3. delivery figures for them in future
4. current stock for these materials
What I need: In pivot table to have a line where I could see calculated future stock. - there I'll see when it goes below zero.
In excel it's done easily:
1. For first week = current stock - consumption + delivery
2. For every next week = previous week calculated stock - consumption + delivery (relative formulas)
Hope in Qlikview that can be done also.
To demonstrate what I need I attach a screenshot with a simple example created in excel. Hope it'll help.
Thanks in advance,
Would you be able to share the raw data behind the chart you are looking for? It would be easier to help if you can provide a qvw or an Excel
Hello Sunny T,
See an excel attached. hope it'll help
Follow this thread for the hints.
rolling up totals in pivot table
Did you get any solution for you problem
Hello. Sorry for a long silence..
No, I have not got a sollution. Now it became again necessary.
I'd appreciate any help from gurus
To make that more clear I made an example in QV and in excel with the same data - what I need (marked with yellow).