topic Re: Networkdays load holidays from table in QlikView

Networkdays load holidays from table

Fri, 30 May 2014 13:03:11 GMT

Hello everybody,

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

Re: Networkdays load holidays from table

Anonymous — Fri, 30 May 2014 19:12:48 GMT

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

See attached, last column in the table.

Re: Networkdays load holidays from table

Mon, 02 Jun 2014 06:07:18 GMT

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?

Re: Networkdays load holidays from table

Anonymous — Mon, 02 Jun 2014 11:02:43 GMT

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.

Re: Re: Networkdays load holidays from table

Wed, 04 Jun 2014 14:00:50 GMT

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