Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I'm struggling getting the holidays from a table in my script. (see example attached) what am i doing wrong.
Holiday list logically is one per application, hence it should be a variable rather than a field.
See attached, last column in the 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?
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.
The problem is that the holidays are different per postal code and country, attached an new example.