5 Replies Latest reply: Sep 19, 2013 7:13 AM by rafael scalabrin RSS

    synthetic tables error

    rafael scalabrin

      Hi all,

       

      I have few tables but in qlikview Im using two:

       

      Table AG:

      AG.ID      PK

      ATEND.ID   FK

      Name

      Number

       

      Table ACCOUNT

      ACCOUNT.ID  PK

      AG.ID       FK

      ATEND.ID    FK

      Name

      Number

      Adress, etc

       

      They are both connected on qlikview by AG.ID and ATEND.ID, it generates a synthetic table with AG.ID and ATEND.ID.

      When I do a research it shows me rows that dont exists, for example, I have same ATEND.ID in both tables, but AG.ID only in AG,

      so it creates in  ACCOUNT a row with AG.ID and ATEND.ID and the other fields blanked (not null, that "-" signal).

       

      What am I doing wrong ?