Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problems with weekly Production`s Plan

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

3 Replies
swuehl
Not applicable

Problems with weekly Production`s Plan

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

Not applicable

Problems with weekly Production`s Plan

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

Not applicable

Problems with weekly Production`s Plan

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