Linking tables in qlikview is quite simple - many issues about data-structures like 1:1, 1:n and so on aren't really relevant in qv to create a working datamodel. The basics are here:
Julio Lourenco wrote:
IF I create a link between those databases, I wonder which one should be the one that would fit my needs. If I link by Date, and I pick the particular Service Center that the Oracle database works with, it somehow filters it, which I don't want to. It is not easy also linking serial numbers, and by clicking in choosing that Service Center for that particular Oracle database, it gets filtered, which should not happen also.
If you are making specific selections of Service Centers or Dates, it is appropriate for the underlying dataset to reduce according to those selections. So I'm not understanding what is the undesired behavior when you state making selections "filters it". Perhaps you could add more as to where the filtration of selections is breaking the application?