Copy a number in a chart to another column and row
I am trying to build an MRP view in Qlikview and I just about have everything working with one exception, getting the Planned Order Release to show up in the right place.
I am calculating that for a given month I need to place an order or I will fall short of needs. That particular item has a 120 day lead time, so the Planned Order Release needs to be 4 months prior to the Planned Order Receipt field.
Does anyone have any idea how to do this? I am attaching what I am working on.
The filed that I am struggling with is Planned Order Releases, which should be the same number as the Planned Order Receipts field, just 120 days earlier.