Hello, I have two tables in QlikView, a Header table and an items table. There is a one (header) to many (items) relationship between the two. They are loaded as sunch (one after another): The 3 Uniques are unique only when combined into DocKey
The problem is that evey load combination I have tried fails, I either can use ItemNumber and ItemPrice OR HeaderNumber and HeaderInfo but I cannot use all, but the joins all work but the tables remain the same.
Thanks! You should seee how complex I tried to make it. This will give a proper one to many join???...I am testing now mut locally and there is a lot of data....It looks loke does, I will take a look at the refresh just finished. I juess creating the %DocKey is not necessary as it will connect on the Unique keys automatically?