2 Replies Latest reply: Jul 17, 2013 8:41 AM by Mike Coleman RSS

    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.

       

      Thanks,

       

      Mike