Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Copy a number in a chart to another column and row

Maybe like attached?

2 Replies
MVP
MVP

Re: Copy a number in a chart to another column and row

Maybe like attached?

Not applicable

Re: Copy a number in a chart to another column and row

Thank you very much, I believe I can make that work.

Community Browser