Probably this document by Henric Cronstrom
is the best reference you can find to do this in QlikView and not in the source database.
Hope that helps.
no, unfortunately that doesn't help me yet - the problem is, for some PNs (personell_numbers), I don't have ANY data in the table for planned_holidays. There is nothing I could use to fill up the missing values.
The problem clearly arises at the point when I join that table to the prior one: I am using a LEFT JOIN, so I should get a result table with all PNs in it, but simply no value in the column "planned" for some of them.
=> In principle, I should be able to use an ISNULL function to find those out.
I'll do some more testing.
Do you have any more ideas for me?
Thanks a lot!