Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Networkdays load holidays from table

Hello everybody,

I'm struggling getting the holidays from a table in my script. (see example attached) what am i doing wrong.

4 Replies
mov
Esteemed Contributor III

Re: Networkdays load holidays from table

Holiday list logically is one per application, hence it should be a variable rather than a field.

See attached, last column in the table.

Not applicable

Re: Networkdays load holidays from table

The problem is that the holidays are different per postal code and country, so in my normal Qlikview application i created a table holidays with country code, postal code from an postal code to and joined it to my orders, isn't there a way to do this?

mov
Esteemed Contributor III

Re: Networkdays load holidays from table

I can't advise you on the data model without knowing a lot of details.

Still, the Holidays are more likely to be the attribute of a the Country rather than the Order.  In the other words - countries have holidays, not orders.

If you can upload your "normal" application, I (or somebody else) will try to help.

Not applicable

Re: Re: Networkdays load holidays from table

The problem is that the holidays are different per postal code and country, attached an new example.

Community Browser