Problems with weekly Production`s Plan

[#1]

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

[swuehl]

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

like

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

[#3]

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

[#4]

EXAMPLE.

if

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....