0 Replies Latest reply: May 21, 2012 3:08 PM by geringer RSS

    Can I use Semantic Table to solve this?

      Hi, I have a specific relationship problem as follows:

       

       

      LotMatch: 

      LOAD

           openTransactionId,

           closeTransactionId,

      FROM ....

       

       

      Transaction:

      LOAD

           transactionId

      FROM....

       

       

      The semantics from the model are 2:M  (where 2 is one for open and one for close as described above

       

       

      I have tried numerous approaches, but cannot entice QlikView to understand my model.  I either get incorrect results, Loops and Memory errors, inconsistency error type D.

       

      Does the Semantic table offer any help for this problem?

       

      Any help would be greatly appreciated...Thanks !