Networkdays load holidays from table

[#1]

Hello everybody,

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

[Anonymous]

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

See attached, last column in the table.

[#3]

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?

[Anonymous]

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.

[#5]

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