Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
joshrussin
Contributor II

scripting help with work days

I had a question. I have this working, but does not account for weekends and holidays in the lead time field. Do you have any suggestions? I tried making a new column in a table with this expression

networkdays (date([Putaway Date (Act.)]), date([ECC Posting Date]), $(vHolidays))

but just returns 0. Here is my script.

MappingTable:

Mapping

LOAD

    "PO Product",

    "Posting Date"

FROM [lib://Data files/ZB_Putaway.xlsx]

(ooxml, embedded labels, table is ECC);

Fact:

LOAD *,

  "Putaway Date (Act.)" - [ECC Posting Date] as [Lead Time];

LOAD Date(ApplyMap('MappingTable', "Purchase Order" & ' ' & Product & ' ' & Batch, 'N/A')) as [ECC Posting Date],

  "PO Material",

    "Purchase Order",

    Product,

    Document,

    Batch,

    "Party Entitled to Dispose",

    "Document Category",

    "Planned Time of Goods Receipt",

    "Actual Goods Receipt Date",

    "Actual Time of Goods Receipt",

    "Planned Time of Unloading",

    "Actual Unloading Date",

    "Actual Time of Unloading",

    "Planned Time of Putaway",

    "Putaway Date (Act.)",

    "Actual Time of Putaway",

    "ERP Document",

    "ERP Document Item"

FROM [lib://Data files/ZB_Putaway.xlsx]

(ooxml, embedded labels, table is eWM);

2 Replies

Re: scripting help with work days

Looks like applymap doesn't have fields in your mapping table. Can you link to one existing field from mapping table to the new table

Life is so rich, and we need to respect to the life !!!
joshrussin
Contributor II

Re: scripting help with work days

Not sure I am grasping what you mean, but here is the table.

Community Browser