topic Problems with weekly Production`s Plan in QlikView

Problems with weekly Production`s Plan

Thu, 28 Jul 2011 15:04:59 GMT

Hello: I´m New with QlikView, and i have and issue

I have the following fields in a QVD.

dInicial, (Inicial Date)

nCdEmpresa, (Enterprise)

dFinal, (Final Date)

iDiasUteis, (Days Between Dates)

nCdProduto, (Product Code)

nQuantidade, (Modified Plan)

nQtdeInicial, (Inicial Plan)

EXAMPLE

nCdEmpresa, (Enterprise) 1

dInicial, (Inicial Date)01/07/2011

dFinal, (Final Date) 06/07/2011

iDiasUteis, (Days Between Dates) 6 days

nCdProduto, (Product Code) 10.000

nQuantidade, (Modified Plan) 6600 units

nQtdeInicial, (Inicial Plan) 6000units

I need that every day has the value of 1000 for inicial plan, and 1100 for Modified Plan.

And how i create the field day, o create a calendar complete?

Thanks, I hope you can help me.

Sorry, my English is a little rusty

Problems with weekly Production`s Plan

swuehl — Sun, 31 Jul 2011 00:48:44 GMT

When loading qvd, you may redefine or overrule the values of the fields,

Load

nCdEmpresa,

dInicial,

dFinal,

iDiasUteis,

nCdProduto,

'1100' as nQuantidade,

'1000' as nQtdeInicial

from ...

For day creation, search for "master calendar" here in the forum.

Regards,

Stefan

Problems with weekly Production`s Plan

Mon, 01 Aug 2011 15:17:40 GMT

The plan is dinamic,

the plan for january for product 10000 is 3000 units,

the plan for march for product 10000 is 3500 units,

etc....

the plan nQtdeInicial is weekly, i need that plan asign each day of the period between inicial date and final date.

Thanks

Problems with weekly Production`s Plan

Thu, 04 Aug 2011 20:32:18 GMT

EXAMPLE.

dInicial 01/07/2011

dFinal 05/072011

nQtdeInicial 5000 units

I need for

01/07 1000 units

02/07 1000 units

03/07 1000 units

04/07 1000 units

05/07 1000 units

In the qvd i haven´t a field data (complete calendar) or something like the style.

Help and thanks....