I still consider myself new to Qlikview. I'm the only one at the company who is designing, developing, and administering anything. I also have an accounting background, so some of this stuff is still lost on me, but I'm learning and having a blast.
We're working with Dynamics GP2013. I've noticed that sometimes my data seems to break when I DON'T have a synthetic key. It seems that the data that makes the most sense to join on is only partial in one table. In an Accounts Receivable app I'm building, the data doesn't seem to work if I don't join on both Customer Number AND Document Number.
Is this normal, or is there something that I am missing?
Also - if anyone knows of any Qlikview Dynamics GP groups, please point them out to me.
If you remove Customer Number and Document Number from one of the table, this will not create a Synthetic Key and the tables would be joined by JoinKey.... Also, both the removed fields are available to both table through the JoinKey