9 Replies Latest reply: Jan 10, 2013 11:43 PM by khadeer basha RSS

    Synthetic tables

      Hello everyone,


      I am joining tables from two different databases (one in SQL, one in Jade)

      I'm trying to design a summary of transaction by employee code (common in both dbs), and transaction type (I've created a conversion table for that), and by date grouped into months.


      This alllowes me to compare transactions in both db at the same time, so that if I change criteria on a list box, it actually filters data in both dbases.

      My summary seems to work but if I check the links, it looks like QlikView has created Synthetic keys, which I believe should be avoided at all cost (Im new to QV).


      Can I avoid this problem, still allowing a user to only enter criteria once?


      Thanks for your time